Excel - I do
Friday, December 02, 2011 | Author: Dav
Greetings,

I use a LOT of Excel in my everyday life. I blame work (of course I blame a lot of things on work, but that's for another blog post).

Crazy, but not that crazy

Excel makes things..orderly. Order is good! Order is next to Godliness I hear. Anyway, I'm sidetracking.

I periodically (re: every Friday) send out an email to some of the guys at work with some weekend music, and after a while I was receiving requests for spesific songs and couldn't keep track of what I've sent out and what I had cued on for the following weeks.

Cue Excel!

So from a 3 column sheet, I progressed on to a 8 column Excel sheet, and more importantly, a drop down for song status where I could select 'Sent' or 'Not Sent'.

After a while (22 new rows) I was sorting each row by Status and I realised the way I was managing the 'Sent' status could be done in a more logical, automatic manner. So I fired up Google and looked up IF statements as well as Nested Statments.


Microsoft's Help page was not so much help because I was not looking for a complex macro. About.com's page on nested IF statements hit the nail on the head for me. This page had a simple to understand example, and got me thinking that I could just simplify an IF formula in Excel to do what I wanted.

My requirements were simple, if I put in a date in a column (Sent Date), I wanted the column (Sent Status) to change to "Sent". If there was no date value, I'd want the column to say "Not Sent".


Warning, formula below!
=IF([@Date]> 1,"Sent", "Not Sent")


Sample excel below FYI
http://www.mediafire.com/?ksktpp1aqraljxg

So I've nerded out this week. I am ashamed.

Dav out

I resolve to call her up a thousand times a day
Ask her if she'll marry me
in some old fashioned way
But my silent fears have gripped me
long before I reach the phone
And before my tongue has tricked me
Must I always be alone



Blog Widget by LinkWithin