Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use large function?
I get a list of numbers as show below
58,58,58,39,39,52,37,43,55,58,55,52. I would like to the largest one, which is 58, and the second largest one, which is 55, and the third largest one, which is 52. But when I use the function large, which don't work the way I describe, and the first, second, third largest numbers is still 58 in this lists. Does anyone have any suggestion on how find the first largest number is 58, and the second largest number is 55, and the third largest number is 52? Thank you in advance Eric |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use large function?
That is because there are 3 58s, so 58 is first, second, third and fourth
largess. If you want to ignore duplicates, use =LARGE(IF(MATCH(B1:B12,B1:B12,0)=ROW(B1:B12)-MIN(ROW(B1:B12))+1,B1:B12),2) which is an array formula, so commit with Ctrl-Shift-Enter. The ,2 at the end is the Large index. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Eric" wrote in message ... I get a list of numbers as show below 58,58,58,39,39,52,37,43,55,58,55,52. I would like to the largest one, which is 58, and the second largest one, which is 55, and the third largest one, which is 52. But when I use the function large, which don't work the way I describe, and the first, second, third largest numbers is still 58 in this lists. Does anyone have any suggestion on how find the first largest number is 58, and the second largest number is 55, and the third largest number is 52? Thank you in advance Eric |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use large function?
Hi,
Try something like this: Say you have 10 numbers in A1:A10, in B1 type: =MAX(A1:A10) in C1: =MAX(IF(A1:A10<B1,A1:A10)) entered using Ctrl+Shift+Enter in D1: =MAX(IF(A1:A10<C1,A1:A10)) again enter using Ctrl+Shift+Enter Hope this helps! Jean-Guy "Eric" wrote: I get a list of numbers as show below 58,58,58,39,39,52,37,43,55,58,55,52. I would like to the largest one, which is 58, and the second largest one, which is 55, and the third largest one, which is 52. But when I use the function large, which don't work the way I describe, and the first, second, third largest numbers is still 58 in this lists. Does anyone have any suggestion on how find the first largest number is 58, and the second largest number is 55, and the third largest number is 52? Thank you in advance Eric |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to use large function?
Thank everyone for suggestions
Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using LARGE Function | Excel Discussion (Misc queries) | |||
IF Function too Large | Excel Discussion (Misc queries) | |||
IF Function too Large | Excel Discussion (Misc queries) | |||
Large function | Excel Worksheet Functions | |||
Help on Large Function | Excel Worksheet Functions |