| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Max function
How can one find the second largest (third, fourth) number in array
a1:a100? |
|
#2
|
|||
|
|||
|
Hi
=LARGE(A1:A100,2) -- Regards Frank Kabel Frankfurt, Germany Stan Altshuller wrote: How can one find the second largest (third, fourth) number in array a1:a100? |
|
#3
|
|||
|
|||
|
Use LARGE, e.g. =LARGE(A1:A100,4)
"Stan Altshuller" wrote in message ... How can one find the second largest (third, fourth) number in array a1:a100? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to list unique values | Excel Worksheet Functions | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| Find a Function to use accross different worksheets | Excel Worksheet Functions | |||
| change function variable prompts?? | Excel Worksheet Functions | |||
| Counting Function Dilemma | Excel Worksheet Functions | |||
Hybrid Mode
