| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Unique Numbers | Excel Worksheet Functions | |||
| Count the number of unique Numbers in a column | Excel Worksheet Functions | |||
| Count unique numbers for execs | Excel Discussion (Misc queries) | |||
| summary count of unique numbers | Excel Discussion (Misc queries) | |||
| count cells with unique numbers | Excel Worksheet Functions | |||
Linear Mode
