- Nov 14, 2005
- Office Version
I have a list, in a table, that has may or may not have duplicates. I am trying to count the number of items, but don't count duplicated items more than once. So if my column contains: A, B, C, A, D, B, A Then my formula would result in the answer of 4. it would not count A or B more than one time. My data is in a Table so I need the formula to function when its filtered. Any suggestions?