Thread: Count equal numbers as unique numbers
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
T. Valko[_2_] T. Valko[_2_] is offline
external usenet poster
  
Posts: 73
Default Count equal numbers as unique numbers
Based on your posted sample data being numeric:

=SUM(--(FREQUENCY(A1:A20,A1:A20)0))


--
Biff
Microsoft Excel MVP


"auyantepui" wrote:

how can I count equal numbers in colum A as unique ones? for example:

Regardless there are 3 (6452301) i need to count them as one Sales Order and
not as three, as so on:

6452302
6452301
6452301
6452301
6452303
6452303
6452303


Reply With QuoteReply With Quote