Posted to microsoft.public.excel.worksheet.functions
|
|
Count unique numbers
Thanks for yor help
/Stilin
"Gary''s Student" skrev:
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
--
Gary''s Student - gsnu200745
"Stilin" wrote:
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.
|