Hi
a non VBA solution. Put the following formula in cell A2
=INDEX($B$1:$D$1,1,MATCH(MAX(B2:D2),B2:D2,0))
and copy this down

--
Regards
Frank Kabel
Frankfurt, Germany


For each row I need to determine which of 3 columns has the max
number
of hours and then populate Column A with the appropriate indicator.

Example of desired results:


MaxHours INVESTMENT CORE MISC
CORE 80 100 3

I am new to Excel macros/VBA and would appreciate any assistance.

Thanks,

Clare Marie
cool:


---
Message posted from http://www.ExcelForum.com/