is this an idea?

starting in f2:
=SUMPRODUCT(N(A1:E1=A2:E2))=5
copy it down.

then use Data/Subtotals on the range
and use col6 as ID.

off the cuff. you may need to adapt.
I use sumproduct() so there's NO need for 'array formula entry'
I use n() to force boolean to integer conversion.



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Ed" wrote:

Not sure if this needs to be VBA or a formula, or even if there's a
built-in function, so I'll start here and let someone drop-kick me in
the right direction.



I've got six columns of information. I need to sub-total as long as
the information in all six columns stays the same; as soon as one item
in one column changes, I start counting at 1 again and sub-total. For
instance:







My first thought is to build a string consisting of all the text
values in the first row, drop a row and build a similar string, and
compare. If they match, increment my count. If they don't match, set
my current count aas the sub-total, take the dis-similar row as the
new starting point, and begin comparing again. Is there an easier and
better way?



Ed