| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Get biggest value, then the smaller one
Hi
I d need a formula to find the biggest value, then the smoller one , and so until about 15 values , from a range like this : AS11:AS42000 . |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Get biggest value, then the smaller one
Hi,
Am Tue, 29 Dec 2020 09:57:12 -0800 (PST) schrieb Xxer Xxes: I d need a formula to find the biggest value, then the smoller one , and so until about 15 values , from a range like this : AS11:AS42000 . try: =LARGE(AS11:AS42000,ROW(1:15)) Regards Claus B. -- Windows10 Office 2016 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Get biggest value, then the smaller one
Windows10
Office 2016 It work perfectly for me . Thank you so much , Sir ! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Biggest Loser Formula | Excel Discussion (Misc queries) | |||
| second biggest in array | Excel Programming | |||
| Finding a name with biggest number | Excel Worksheet Functions | |||
| Biggest commercial .xla file? | Excel Programming | |||
| Determining biggest variable | Excel Programming | |||
Hybrid Mode
