LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel function LARGE returns error 'too few arguments' Browndoff Excel Worksheet Functions 5 July 26th 06 09:55 PM
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
Large Function wjohnson Excel Worksheet Functions 7 February 23rd 06 11:48 PM
Automatically up date time in a cell Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM
Help on Large Function Master Excel Worksheet Functions 8 February 19th 05 01:45 PM


All times are GMT +1. The time now is 05:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"