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:



Date Store Item Style Color Size

1/1/04 A Shoe This Blue 10

1/1/04 A Shoe This Blue 10

1/1/04 A Shoe This Blue 10

1/1/04 A Shoe This Blue 10

1/1/04 A Shoe This Red 10 << new start

1/1/04 A Shoe This Red 10

1/1/04 A Shoe This Red 10

1/1/04 A Shoe This Red 10

1/1/04 B Shoe This Red 10 << new start

1/1/04 B Shoe This Red 10

1/1/04 B Shoe This Red 11 << new start

1/1/04 B Shoe This Red 11



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