what formula?

[vrejka]

Hiya,

I have a listing of returns. Each return has a reference number. If customer returns more than 1 item, the reference number will be listed on spreadsheet more than once.
Well now I managed to count how many returns in each month we receive (not counting duplicates) by using this formula
SUMPRODUCT((A:A<>"")/COUNTIF(A:A,A:A&"")) but now I need a count by date......

So for example we have 124 returns in june so far but now i will need to find out how many we received each day.

Any help?

Thanks

V

 

[SteveO59L]

Try a pivot table

 

[vrejka]

so there is now way that formula would do it?

 

[Robert Mika]

Look here:
http://www.xl-central.com/count-unique-values.html

 

[vrejka]

haven't find it really :/