Michael Dean
asked on
How to Get a Count of Unique Values and paste them on a different tab
I have a spreadsheet (same attached)
I want to be able to count the number of values appearing in Column G (Tests Sheet), however since there are duplicate occurrences I would only count the dup once.
I want to use the returning value on the (totals tab) column C8
Test-scripts-8-06._03132107.xlsx
I want to be able to count the number of values appearing in Column G (Tests Sheet), however since there are duplicate occurrences I would only count the dup once.
I want to use the returning value on the (totals tab) column C8
Test-scripts-8-06._03132107.xlsx
try the method stated here
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you also want to list of Unique values, please find attached..
Test-scripts-8-06._03132107_v1.xlsx
Test-scripts-8-06._03132107_v1.xlsx