count uniques in same column, post in blank cell, repeat until end ofspreadsheet
A macro that fills the next blank row in same column as represented
below.
Column A
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.
|