On Jan 15, 11:43*am, merjet wrote:
You could describe your problem better. An example
would probably help. Maybe the menu Data | Filter |
Advanced Filter | Unique Records Only can get you
started.

Hth,
Merjet

A macro that does this:

Let my try again.....for clarification:

Column A (now)


A
A
A
N
N
N
N
[blank cell] result should be "2" - keep going
A
A
J
L
F
F
F
[blank cell] result should be "4"- keep going until you get to the
end of the spreadsheet.