Count, unique

[smegson88]

I am having a dreadful time trying to get a value using data from one sheet to a total in another sheet.

There are "load dates", and i need to count the total number of load dates at the end of a month, however, if the dates are for example 15-jan, 15-jan, 16-jan then i need the count to return a value of 2, not count every single date.

How can i do this? i have tried everything i can think of.....

 

[Krishnakumar]

Hi smegson88,

Welcome to the MrExcel Board!

Try,

=COUNT(UNIQUEVALUES(your_range_here))

Hold Ctrl and Shift keys while pressing Enter.

To work this you need to install the MOREFUNC Add-In.

You can download it from here

Kris

 

[Brian from Maui]

Try,

=SUMPRODUCT((A1:A10<>"")/COUNTIF(A1:A10,A1:A10&""))

If you download the Morefunc addin, try this as well

=COUNTDIFF(A1:A10)

 

[KenWright]

If they are real dates you can also use

=SUMPRODUCT(1/COUNTIF(A1:A30,A1:A30))