Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Column Heading after lookup
Ok guys, here's one to work those muscles. So far I have the following
formula: SUMPRODUCT(--(Test.xls!$G$23:$G$6500=B20),--('[Test.xls]Test'!$J$23:$J$6500=F20),--('[Test.xls]Test'!$O$23:$O$6500)+--('[Test.xls]Test'!$P$23:$P$6500)+--('[Test.xls]Test'!$Q$23:$Q$6500)+--('[Test.xls]Test'!$R$23:$R$6500)+--('[Test.xls]Test'!$S$23:$S$6500)+--('[Test.xls]Test'!$T$23:$T$6500)+--('[Test.xls]Test'!$U$23:$U$6500)) This is just looking for a few criterias and return the sum of a few columns. Now, I just want it to look if any of those columns have data greater 0 and return the column heading for that column, it'll only be one column out of all of those columns that will have data, now, what do i do? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Column Heading after lookup
Any ideas guys?
"Javier Diaz" wrote: Ok guys, here's one to work those muscles. So far I have the following formula: SUMPRODUCT(--(Test.xls!$G$23:$G$6500=B20),--('[Test.xls]Test'!$J$23:$J$6500=F20),--('[Test.xls]Test'!$O$23:$O$6500)+--('[Test.xls]Test'!$P$23:$P$6500)+--('[Test.xls]Test'!$Q$23:$Q$6500)+--('[Test.xls]Test'!$R$23:$R$6500)+--('[Test.xls]Test'!$S$23:$S$6500)+--('[Test.xls]Test'!$T$23:$T$6500)+--('[Test.xls]Test'!$U$23:$U$6500)) This is just looking for a few criterias and return the sum of a few columns. Now, I just want it to look if any of those columns have data greater 0 and return the column heading for that column, it'll only be one column out of all of those columns that will have data, now, what do i do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
LOOKUP and return the column heading for IF/THEN return for False | Excel Discussion (Misc queries) | |||
I have an IF formula to return column heading for FALSE | Excel Discussion (Misc queries) | |||
IF formula to return column heading for False logic | Excel Discussion (Misc queries) | |||
Formula to Return Column Heading | Excel Discussion (Misc queries) | |||
Lookup min & column heading | Excel Worksheet Functions |