ExcelBanter - Get biggest value, then the smaller one

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Get biggest value, then the smaller one (https://www.excelbanter.com/excel-worksheet-functions/455017-get-biggest-value-then-smaller-one.html)

Xxer Xxes

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 .

Claus Busch

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

Xxer Xxes

Get biggest value, then the smaller one

Windows10
Office 2016

It work perfectly for me .
Thank you so much , Sir !

All times are GMT +1. The time now is 05:57 AM.