| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to construct a count count formula
I have a list of stores with many order numbers, the order numbers are
duplicated. I need to count the unique number of order numbers according to each store without manually removing duplicates etc. within excel 2007. e.g. Store Order Number apost 100124 apost dave101 apost dave101 apost 100024 fone 115 fone 1000214 fone lar1004 fone 1000214 fone 10021 Result apost 3 fone 4 -- Chris K Excel user |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Formula - Count Ticks | Excel Discussion (Misc queries) | |||
| Count Employee Work Time - Don't Double-count Overlapping Apts. | Excel Worksheet Functions | |||
| Excel 2000, count, sort a list & count totals? | Excel Worksheet Functions | |||
| Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
| Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions | |||
Threaded Mode
