Need lookup of data both vertical and horizontal
Hi,
I am trying to summarise data on 2 axes:
Name: John Fred Michael
Date:
01/01/00 L
01/02/00 L
I need a formula / pivot table to search all the data, and where the letter
'L' appears, return the relevant name and date from the column and row
headers.
Any ideas on which approach and how to format the data? I'd be grateful :-)
Thanks
|