Count Uniques in Column, put result in next blank cell andcontinue until last row
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.
|