x404.co.uk
http://www.x404.co.uk/forum/

Excel help please
http://www.x404.co.uk/forum/viewtopic.php?f=3&t=14435		 Page 1 of 1
Author:  okenobi [ Wed Aug 10, 2011 12:02 pm ]
Post subject:  Excel help please
I have a sheet with all my guests on it. At the moment I use a spare cell where I plug in today's date and then a nested IF statement looks at that date and compares it with the departure and arrival date in each row to determine whether or not the guests are "Future", "Current" or "Departed". If then use autofilter to show just the Current guests.

I'm wondering if there's a way using VLOOKUP or something to make this more sophisticated? Thing is, with the autofilter, I can select individual dates to know when to write goodbye letters to people etc, but I was just thinking maybe there's a more elegant solution that IFs and filters. Maybe there just isn't. Any thoughts? If not, no worries.
Author:  jonlumb [ Wed Aug 10, 2011 12:05 pm ]
Post subject:  Re: Excel help please
PM sent
Author:  okenobi [ Wed Aug 10, 2011 2:25 pm ]
Post subject:  Re: Excel help please
Thanks Jon. Very helpful :)
Author:  koli [ Wed Aug 10, 2011 5:31 pm ]
Post subject:  Re: Excel help please
The way I would do this is to use conditional formatting option on the cell so when the value of the cell turns to "Current", the filling of that cell (I prefer the entire row myself though) will become bright yellow or similar. So at a glance you will be able to tell what's happening.

This won't help if you have too many rows and you don't want to scroll but it seems you solved it already so I won't go into more complicated solutions. Unless you insist of course...
Author:  okenobi [ Thu Aug 11, 2011 4:54 pm ]
Post subject:  Re: Excel help please
koli wrote:
The way I would do this is to use conditional formatting option on the cell so when the value of the cell turns to "Current", the filling of that cell (I prefer the entire row myself though) will become bright yellow or similar. So at a glance you will be able to tell what's happening.

This won't help if you have too many rows and you don't want to scroll but it seems you solved it already so I won't go into more complicated solutions. Unless you insist of course...


Nah, I'm good thanks! :D
Page 1 of 1 All times are UTC
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/