Remember Me?

#1
September 19th 07, 10:34 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Sep 2007 Posts: 2
Count unique numbers

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.

#2
September 19th 07, 11:34 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 11,058
Count unique numbers

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.

#3
September 19th 07, 12:04 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Sep 2007 Posts: 2
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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Averitt Engineer Excel Worksheet Functions 6 February 14th 07 09:26 PM ajajmannen Excel Worksheet Functions 20 May 10th 06 06:03 PM DanielJW Excel Discussion (Misc queries) 2 November 29th 05 10:47 AM Dave Edge Excel Discussion (Misc queries) 5 November 12th 05 12:06 AM Alex Excel Worksheet Functions 1 February 21st 05 07:46 PM

All times are GMT +1. The time now is 06:51 AM.