Link to home
Start Free TrialLog in
Avatar of Michael Dean
Michael DeanFlag for United States of America

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
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

try the method stated here
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
If you also want to list of Unique values, please find attached..
Test-scripts-8-06._03132107_v1.xlsx