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