Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi folks,
I've run into a situation where I'm not sure what to do with it. I have seven columns: A B C D F X and POP beneath the letter colums are totals which can be of values 0 through 11. What I ultimately want to do is have a formula in the pop cell corresponding to each row of data which finds the maximum value and shows the column name corresponding to it. Following is an example of what I'd like POP to reflect based on sample data: A B C D F X POP 2 0 0 7 2 0 D 3 2 0 2 4 0 F 6 3 2 0 0 0 A etc... If anyone can give me an idea of which route to follow I'd appreciate it. Regards Ben/ND |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel formula - Anyone up for a challenge? | Excel Discussion (Misc queries) | |||
Excel 2002 Challenge | Excel Discussion (Misc queries) | |||
A challenge for an Excel Master... | Excel Discussion (Misc queries) | |||
A Challenge (Linking word and Excel) | Excel Programming | |||
Challenge...Excel Chart to Power Point | Excel Programming |