Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a chart of numbers, lets say it is 10 by 10 with different amounts in
each. I want to find which column, for each row, has the Largest number. I know I need to use the LARGE formula but I don't want it to tell me what the number is but which column it is in. Example A B C D E F G H I 1 2 3 4 5 NUM LRG 1 09 12 08 04 15 1 5 2 17 02 08 20 03 2 4 3 02 01 07 05 03 3 3 4 25 06 17 18 09 4 1 I would then have column H have 1 - 4 and Column I would have which row the largest number in: I know I can use the LARGE formula like =LARGE(B2:F2,1) to give me which number is largest but how do I then tell it so show me which column in B1:F1? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel function LARGE returns error 'too few arguments' | Excel Worksheet Functions | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Large Function | Excel Worksheet Functions | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
Help on Large Function | Excel Worksheet Functions |