Sequential Numbering.
I have a column of numbers in
assorted sequential but non contiguous blocks from 4 to 30. I seek a formula to renumber them 1 and onwards, until a lower number is found, whereupon they would begin again at 1. Can anyone assist please? eg: Col A 2 3 6 8 13 4 5 6 8 12 21 I seek Column B to show 1 2 3 4 5 1 2 3 4 5 6 |
enter 1 in B1
enter =IF(A2A1,B1+1,1) in B2 and copy it down Regards -- Greetings from New Zealand Bill K "Rodney" wrote in message ... I have a column of numbers in assorted sequential but non contiguous blocks from 4 to 30. I seek a formula to renumber them 1 and onwards, until a lower number is found, whereupon they would begin again at 1. Can anyone assist please? eg: Col A 2 3 6 8 13 4 5 6 8 12 21 I seek Column B to show 1 2 3 4 5 1 2 3 4 5 6 |
Thanks Bill.
Worked a treat. Regards from Perth. "Bill Kuunders" wrote in message ... | enter 1 in B1 | enter =IF(A2A1,B1+1,1) in B2 and copy it down | | Regards | | -- | Greetings from New Zealand | Bill K |
You're welcome.
Thanks for the feedback. Bill K "Rodney" wrote in message ... Thanks Bill. Worked a treat. Regards from Perth. "Bill Kuunders" wrote in message ... | enter 1 in B1 | enter =IF(A2A1,B1+1,1) in B2 and copy it down | | Regards | | -- | Greetings from New Zealand | Bill K |
All times are GMT +1. The time now is 08:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com