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
EE_alternating-row-numbers.xlsx
Take a look at the formulas that I have added for 3 & 4, see if it works for you.
EE_alternating-row-numbers.xlsx
EE_alternating-row-numbers.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
=B11+1
And copy that down into each of the number cells below it.
»bp