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
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)