Auto Numbering of data except blanks starting from number n

NoSparks · #1 09-07-2018, 08:32 PM

another possibility:

assuming the 58 in your example is in A34, try this in A35 and drag down

Code:

=IF(B35="","",MAX($A$34:$A34)+1)

don't know where the first number on sheet 2 would be, but something like this in the cell should get the next number

Code:

=MAX(Sheet1!$A$34:$A$500)+1

Marcia · #2 09-08-2018, 01:27 PM

Thank you, but the formula returns numbers that automatically start at 1, it should be 59, the next number after 58. I have copied the sample made by Logit with a macro. I would prefer a formula if it could be done please.

Marcia · #3 09-08-2018, 02:18 PM

Please read my previous message, in reply to your formula. I have attached the sample data. Thanks.

Marcia · #4 09-08-2018, 03:12 PM

Quote:

Originally Posted by NoSparks

another possibility:

assuming the 58 in your example is in A34, try this in A35 and drag down

Code:

=IF(B35="","",MAX($A$34:$A34)+1)

don't know where the first number on sheet 2 would be, but something like this in the cell should get the next number

Code:

=MAX(Sheet1!$A$34:$A$500)+1

The IF MAX formula works!! I applied it on my worksheet and at first it returned 1,2,3 but when I retyped 58 on the cell above the formula. The correct numbers popped out. I am now learning the macro of it.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Return Multiple values from data except blanks with two criteria	Marcia	Excel	7	09-07-2018 12:38 AM
Delete starting number *) and delete Unneeded data in series	frustrated teacher	Word VBA	5	12-07-2014 06:53 PM
Starting page numbering after initial pages	plradoff	Word	3	02-15-2014 08:59 PM
Copying data from sheet with deleted columns creates blanks	ZGreyArea	Excel	1	11-20-2013 10:12 AM
Page numbering starting on 2 after section break	pamm13	Word	1	06-22-2011 11:10 AM