One way
In say, B1:
=SUMPRODUCT((A1:A10<"")/COUNTIF(A1:A10,A1:A10&""))
High-five? Click YES button below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"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