1. Forum
  2. Usenet
  3. MICROSOFT.PUBLIC.EXCEL

  • Finding 6 largest consecutive values

    From Adrian@21:1/5 to All on Sun May 8 04:13:35 2022
    I have column A with a lot of values, like this:
    4261
    7836
    6873
    8437
    7635
    6736
    6873
    6873
    8944
    6625
    (more...)

    I need to find a range of 6 consecutive values extracted from column A, which contain the largest numbers.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Stephen Wolstenholme@21:1/5 to All on Sun May 8 14:19:20 2022
    On Sun, 8 May 2022 04:13:35 -0700 (PDT), Adrian <adi.sav@gmail.com>
    wrote:

    I have column A with a lot of values, like this:
    4261
    7836
    6873
    8437
    7635
    6736
    6873
    6873
    8944
    6625
    (more...)

    I need to find a range of 6 consecutive values extracted from column A, which contain the largest numbers.

    I would select the whole column of values an then get Excel Insert
    Chart to draw a line graph and then click on 6 peaks.

    Steve

    --
    Neural Network Software for Windows http://www.npsnn.com

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Claus Busch@21:1/5 to All on Sun May 8 16:54:31 2022
    Hi Adrian,

    Am Sun, 8 May 2022 04:13:35 -0700 (PDT) schrieb Adrian:

    I have column A with a lot of values, like this:
    4261
    7836
    6873
    8437
    7635
    6736
    6873
    6873
    8944
    6625
    (more...)

    I need to find a range of 6 consecutive values extracted from column A, which contain the largest numbers.

    have a look:
    https://1drv.ms/x/s!AqMiGBK2qniTgfJdNX-AWT_5ZEHUhw?e=wLfyQN


    Regards
    Claus B.
    --
    Windows10
    Microsoft 365 for business

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