Link to home
Start Free TrialLog in
Avatar of agwalsh
agwalsh

asked on

Formula to autocalculate an item number - where there is a blank row between each entry

I have a list of numbered entries - they are as follows - number then blank row, then number plus one etc. (See attached file).  Yes, it would be better to have no blank rows but that suggestion was shot down :-(. Any suggestions on what formula I could use so that if - for example - I have to insert an entry between the current 3 and 4 , all the subsequent numbers auto correct to the new sequence?
EE_alternating-row-numbers.xlsx
Avatar of Bill Prew
Bill Prew

Starting in B13 just use:

=B11+1

And copy that down into each of the number cells below it.


»bp
Take a look at the formulas that I have added for  3 & 4, see if it works for you.
EE_alternating-row-numbers.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of agwalsh

ASKER

@Saqib Husain, Syed - this is a humdinger of a formula - but it does exactly what is required :-) The user is not technical but I tried it out and all he has to do is copy it down.. woo-hoo! @Roy Cox - I tried your formula as well but it didn't copy down as effortlessly as @Saqib Husain, Syed's. @Bill Prew - had tried that already - but thank you for your help.