View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
S Himmelrich S Himmelrich is offline
external usenet poster
 
Posts: 76
Default Count Uniques in Column, put result in next blank cell andcontinue until last row

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.