Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hello--
I have a table that looks like this: 135569 135572 135574 135577 135578 7664502273 1 1 1 1 7664505027 1 1 1 1 9.78158E+11 1 For each row, I need to pull the column heading for any instances where there is a 1 and have that entered in it's own separate cell or separated by a comma if in a single cell. I've tried some index functions, but am not having any luck. Any ideas?? Thanks so much for your help!!! Cecilia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How doI changes my row and column heading color? | Excel Discussion (Misc queries) | |||
In a table produce an value by column heading and row heading | Excel Worksheet Functions | |||
Lookup min & column heading | Excel Worksheet Functions | |||
column heading | Excel Discussion (Misc queries) | |||
Need to put a name in the column heading | Excel Discussion (Misc queries) |