Adding sequential numbers

Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
Hello,

I would like a formula that in a group of 10 numbers listed, for example, assigns the next consecutive number to a randomly marked number of the ten. As an example, in ten numbers 5, 9 and 7 are checked in that order. Excel formula marks 5 as number one, 9 as number two and 7 as number three. As number 6 is checked, the formula sees that number three is the highest number marked and consequently designates 6 as the number four number in the sequence.

Thank you.

Gary

1 reply

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
Hi Gary,

Can you explain what the purpose is, what you want to achieve with this?

Best regards,
Trowa