1. Forum
  2. Usenet
  3. MSOFT.PUB.EXCEL.WORKSHEET

  • Get biggest value, then the smaller one

    From Xxer Xxes@21:1/5 to All on Tue Dec 29 09:57:12 2020
    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 .

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Claus Busch@21:1/5 to All on Tue Dec 29 19:04:02 2020
    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)
  • From Xxer Xxes@21:1/5 to All on Tue Dec 29 11:17:07 2020
    Windows10
    Office 2016

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

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)