How to Get a Count of Unique Values and paste them on a different tab

seamus9909
seamus9909 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2016

Commented:
try the method stated here
Managing Director/Excel VBA Developer
Distinguished Expert 2018
Commented:
Try this:
=SUM(IF(FREQUENCY(Tests!G:G,Tests!G:G)>0,1))

Open in new window

Test-scripts-8-06._03132107.xlsx
ShumsManaging Director/Excel VBA Developer
Distinguished Expert 2018

Commented:
If you also want to list of Unique values, please find attached..
Test-scripts-8-06._03132107_v1.xlsx

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial