Microsoft Office Forums - View Single Post - [Solved] Auto Numbering of data except blanks starting from number n

Thread: [Solved] Auto Numbering of data except blanks starting from number n

View Single Post

Old

09-08-2018, 01:27 PM

Marcia

Marcia is offline

Marcia uses Windows 7 32bit

Windows 7 32bit Marcia uses Office 2007

Marcia uses Office 2007

Office 2007

Expert

The original poster

Join Date: May 2018

Location: Philippines

Posts: 527

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Default

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.

Attached Files

Number NonBlank Rows (2).xlsm (25.6 KB, 7 views)

Reply With Quote