| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count unique numbers in a range with a given criteria
Hi!
How can I count the unique numbers in a range where I have numbers, blank cells and text, everytime a condition is met? It's like this: Source page Supplier Nº Date 28000 01-01-2007 28001 01-01-2007 jtrjkfff 01-01-2007 28000 01-01-2007 28001 02-01-2007 (blank) 02-01-2007 ddfgdr 02-01-2007 28001 02-01-2007 Results page Date Count of Suppliers 01-01-2007 2 02-01-2007 1 .... Thanks a lot! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unique RANDOM NUMBERS within specified range | Excel Worksheet Functions | |||
| Count Unique records based on the Criteria in another colum | Excel Worksheet Functions | |||
| Count Unique records based on the Criteria in another colum | Excel Worksheet Functions | |||
| Count unique items in range | Excel Worksheet Functions | |||
| How do I count data in range A:A that is dependent upon criteria . | Excel Worksheet Functions | |||
Threaded Mode
