Thread: How to create a repeat set of sequence number index where values appear in a row

Hi,

It's hard to explain what I want to achieve so I apologise if I confuse you here. I've included a sample excel (attached) and highlighted what I want to achieve in red.

I have a set of data in excel and I want to insert a new column A to contain a numeric index but I would like the numbers to repeat if that row contains any values, otherwise, if the row is completely empty, then that row index is blank or has a symbol/zero (doesn't matter). The next row containing values, the index would then contain the next number.

That was terrible, sorry. Here's another example of what i'm trying to achieve:

A B C D
1 word word
1 word word
1 word
1 word
1 word
*
2 word word
2 word word
2 word
2 word
2 word
*
3 word word
3 word word
3 word
3 word
3 word


Hope that helps.
Thanks!

Try this in A5

=IF(COUNTA(B5:F5)=0,"",MAX($A$4:$A4)+1)

Drag/Fill Down

Is that what you need?

Okay.
In A4

1

Then in A5

=IF(AND(A4<>"",COUNTA(B5:G5)>0),MAX($A$4:$A4),IF(AND(A4="",COUNTA(B5:G5)>0),MAX($A$4:$A4)+1,""))

Drag/Fill Down

in a4 assuming single blanks are only between sets in col g
=IF(G4="","",1+COUNTIF($G$4:G4,""))

@Martin Neat!

@ tiggi
If you only have one seperating blank row between groups, go with Martin.
My offering will work if there can be, or are, more than one seperating blank rows between groups.