Duplicates, can I count the Original but ignore 2nd, 3rd etc

Stuart Wildman
Stuart Wildman ✭✭
edited 12/09/19 in Formulas and Functions

Hi

I had a look but couldn't find the answer.

I am trying to do simple reports and formula Counts, but trying to ignore any duplicates.

Example below, I am only interested in counting the first time a name appears, so the count would equal 5 Names, ignoring where there is a second or third.

Names

Andrew

Dave

Phil

Sarah

Phil

George

Dave

Dave

Β 

Β 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!