View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
David David is offline
external usenet poster
 
Posts: 1,560
Default Using LARGE Function

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?