Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count but ignore duplicate data
Hi Expert, I need your help on how to count data but to ignore duplicates.
Below count results should be = 3 (ignore duplicates) Inv No. 9123 9123 9125 9128 9128 Thanks for your support, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ignore Hidden Rows and Count of distinct values | Excel Worksheet Functions | |||
multiple criteria count formula with duplicate data | Excel Worksheet Functions | |||
Ignore text but count values in same cell | Excel Discussion (Misc queries) | |||
Using SUM function to count hours BUT ignore Letters? | Excel Worksheet Functions | |||
Count Duplicate Numbers | Excel Worksheet Functions |