Auto Numbering of data except blanks starting from number n

		Microsoft Office Forums > Microsoft Excel > Excel
Auto Numbering of data except blanks starting from number n

09-07-2018, 08:32 PM

NoSparks

Windows 7 64bit Auto Numbering of data except blanks starting from number n

Office 2010 64bit

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

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

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

Other Forums: Access Forums

All times are GMT -7. The time now is 12:21 AM.