How: Show Value of Header Row if there is any Value in the Data Row?

**bmasella** · 11-11-2011, 09:18 PM

I have a worksheet with values in the header row (row 1)... they are text....
In column A I have dates....

What I want is to see in almost a dashboard or chart view of some kind all of the header rows if there is any value in today's day. Anyone have any ideas how I might accomplish?

PHP Code:


     A                B            C                D 
1                    Tom         Rich         Harry 
2 11/11/11           A 
3 11/12/11           A:25                          C 
4 11/13/11           C             T 
5 11/16/11

If today is 11/11 what I would like the output to be:

Tom - A

If today is 11/12 I would like the output to be:

Tom - A:25
Harry - C

If today is 11/13

Tom - C
Rich - T

If today is 11/16 the output would be

NONE

**Marcol** · 11-12-2011, 10:48 AM

You don't state what version of Excel you need this to work with.

This should work with 2007 and above.
It can be made more dynamic, but first see if it does what you require.

Select from the dropdown in B10