Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Finding 6 largest consecutive values

7 views
Skip to first unread message

Adrian

unread,
May 8, 2022, 7:13:38 AM5/8/22
to
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.

Stephen Wolstenholme

unread,
May 8, 2022, 9:19:25 AM5/8/22
to
On Sun, 8 May 2022 04:13:35 -0700 (PDT), Adrian <adi...@gmail.com>
wrote:
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

Claus Busch

unread,
May 8, 2022, 10:54:36 AM5/8/22
to
Hi Adrian,
have a look:
https://1drv.ms/x/s!AqMiGBK2qniTgfJdNX-AWT_5ZEHUhw?e=wLfyQN


Regards
Claus B.
--
Windows10
Microsoft 365 for business
0 new messages