Count unique numbers

[Guest]

Hi!
I have a spreadsheet in wich I have timevalues (in A3:A750).
I also have av timemark 1 to 6 (in H3:H750).
I need help with a formula that gives me the summing of how many unique
timevalues there is together with the timemark 1 or 2 or .... 6.

 

[Guest]

In Z3 ( or any other un-used column ) enter:

=H3 & A3 and copy down

then see:

http://www.cpearson.com/excel/Duplicates.aspx
especially the section entitled:

Counting Distinct Entries In A Range

 

[Guest]

Thanks for yor help
/Stilin

"Gary''s Student" skrev: