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).
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!
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
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
0 comments: