Forum Discussion

Copper Contributor

Jul 10, 2020

Sequential numbers that change when deleted.

Hi all, Is there a way of making automatic counting down a column. I am comfortable to input progressive numbers. i.e. 1-36 down a column. But is there a formula that will edit following num...

BI & Data Analysis

excel

Excel on Mac

Formulas and Functions

Subodh_Tiwari_sktneer

Silver Contributor

Jul 10, 2020

robglaysher

If you want to insert the sequential numbers in the range A1:A36, input 1 manually in the cell A1 and then place the following formula in A2

=MAX(A$1:A1)+1

and then copy it down.

So if you delete any number in between, the next number will be changed accordingly i.e. the sequential numbers will ignore the blank cells like this...

Or you may try this formula in A37 which will give you the count of numbers entered in the range A1:A36

=COUNT(A1:A36) ( this will count the numbers entered in the range A1:A36)

=COUNTA(A1:A36) (this will count the cells which have either text of numbers in them in the range A1:A36)

IrisJ
Copper Contributor
Apr 24, 2021
Subodh_Tiwari_sktneer
Hi, I am a complete novice when it comes to numbering and I'm so tired of being frustrated with something as simple as entering numbers 123..... I have to add names and sometimes delete... When I do this the numbering of course is off and I don't know how to correctly input the function and or sequence function to assist me. I have the Office product for MacBook ...I purchased MacBook student 2019.
Anyway I can get a tutorial for how to?
- Subodh_Tiwari_sktneer
  Silver Contributor
  Apr 24, 2021
  IrisJ
  I would suggest you to open your own question by describing what exactly you are trying to achieve.
  It would be helpful if you upload a sample file with the desired output on a different sheet mocked up manually to show the end result you are after.