Thread: counting recurring #'s in a column
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
  
Posts: 2,480
Default counting recurring #'s in a column
Hi

With data in column A, enter in B1
=COUNTIF(A:A,A1)
and copy down

--
Regards
Roger Govier



"okie7392" wrote in message
...
I am trying to count the number of times each # within a column repeats
it's
self.
I am completely lost!


Reply With QuoteReply With Quote