Continuing Number Series with Word excluding blanks

[dibison18]

This might seem like a simple question but I am having a hard time figuring it out. Below is a table where I want to delete "Tab 3" (in cell C3) and I want the following cells C4 and C5 to auto-re-number to Tab 3 and Tab 4, respectively. I want to be able to do this on a continual basis so sometimes I want to delete cell C2 and C4 and have cells C3 and C5 auto-re-numbered. At times, I might want to also delete cell C1 and want the cells after to auto-re-number. Thanks for any help you can provide!

9 - 10 AM	Call Tim	Tab 1
10:15 - 10:45 AM	Meeting Bandit	Tab 2
11:00 - 11:15 AM	Chicken Dance	Tab 3
11:30 AM - 12:00 PM	Feast	Tab 4
12:30 PM - 1:00 PM	Noithing	Tab 5

 

[MrTomasz]

try:

="Tab " & ROW(C1)

 

[Eric W]

Maybe:

Book1
	A	B	C
1
2	9 - 10 AM	Call Tim	Tab 1
3	10:15 - 10:45 AM	Meeting Bandit	Tab 2
4	11:00 - 11:15 AM	Chicken Dance	Tab 3
5	11:30 AM - 12:00 PM	Feast	Tab 4
6	12:30 PM - 1:00 PM	Noithing	Tab 5
Sheet10

Cell Formulas
Range	Formula
C2:C6	C2	="Tab "&ROWS(C$1:C2)-COUNTBLANK(C$1:C1)

 

[Rick Rothstein]

If I understand what you want correctly, and assuming your data starts on Row 1 (meaning there are no headers), type "Tab 1" in cell C1 and then put this formula in cell C2 and copy it down to the bottom of your data...

="Tab "&COUNTA(C$1:C1)+1

If you have a header in cell C1 and your data actually starts on Row 2, then put this formula in cell C2 and copy it down...

="Tab "&COUNTA(C$1:C1)

 

[dibison18]

Thank you both so much... both solutions worked!