Skip to Content
Jul 18, 2017 at 04:16 PM

Not Count Doubles ID


Hi community,

Simple question, need your help.

My Request return me some ID in a table. Like here:

SD010 test1

SD011 test2

SD012 test3

SD010 test2

SD0113 test4

SD010 test34

I would like to count not duplicate SDs

So I need to count only SD011+SD012+SD113 = 3 (SDs)

Formula like =Count([SD]) return 6

Formulf like =Count([SD];DISTINCT) return also 6

I need =Count(something SD) need to return 3

How it resolve by formula ?