Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need lookup of data both vertical and horizontal
"rmargh" wrote in message
... 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 Have a look here for an explanation of how to use MATCH inside an OFFSET formula. http://www.cpearson.com/excel/lookups.htm#LeftLookup This would get the name for you. Putting the MATCH as the third parameter of the OFFSET rather than the second would get the name. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need lookup of data both vertical and horizontal
Cheers Stephen :-)
"Stephen" wrote: "rmargh" wrote in message ... 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 Have a look here for an explanation of how to use MATCH inside an OFFSET formula. http://www.cpearson.com/excel/lookups.htm#LeftLookup This would get the name for you. Putting the MATCH as the third parameter of the OFFSET rather than the second would get the name. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn vertical data to horizontal data automaticaly | Excel Worksheet Functions | |||
transposing vertical data to horizontal with varying amount of data | Excel Discussion (Misc queries) | |||
How to make Horizontal data go Vertical | Excel Worksheet Functions | |||
Horizontal data to vertical data | Excel Discussion (Misc queries) | |||
tranfere vertical data to horizontal tabel | Excel Worksheet Functions |