Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Excel Numbering - Treat highlighted and non-highlighted rows differently.

Avatar of Nick Wolf
Nick WolfFlag for United States of America asked on
Microsoft AccessMicrosoft Excel
12 Comments1 Solution627 ViewsLast Modified:
   I have an Excel (2007) spreadsheet with 8100 rows of data. Some rows are highlighted consecutively in pairs, threes, or greater numbers, the other rows are non-highlighted. I need help numbering these rows with a formula, macro, or however.

    I need for the spreadsheet numbering to start with a group of non-highlighted rows (ie. 1, 2, 3 ...), and when it gets to a group of highlighted rows (ie. 11, 12), treat the group of highlighted rows as a single row and number accordingly. (See the attached image for clarification).

    For example:
Number as 1---->  ROW 1 - [Text, no highlighting.]
Number as 2---->  ROW 2 - [Text, no highlighting.]
Number as 3---->  ROW 3 - [Text, no highlighting.]
Number as 4---->  ROW 4 - [Text, no highlighting.]
Number as 5---->  ROW 5 - [Text, no highlighting.]
Number as 6---->  ROW 6 - [Text, no highlighting.]
Number as 7---->  ROW 7 - [Text, no highlighting.]
Number as 8---->  ROW 8 - [Text, no highlighting.]
Number as 9---->  ROW 9 - [Text, no highlighting.]
Number as 10---->  ROW 10 - [Text, no highlighting.]
Number as 11---->  ROW 11 - [Text, HIGHLIGHTED.]
Number as 11---->  ROW 12 - [Text, HIGHLIGHTED.]
Number as 12---->  ROW 13 - [Text, no highlighting.]
Number as 13---->  ROW 14 - [Text, no highlighting.]
Avatar of sstampf
sstampfFlag of India image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

This problem has been solved!
Unlock 1 Answer and 12 Comments.
See Answers