count value is different

[realpixel]

Hello,

I use the function count to count the column 'PEV', it's works fine but I need to count only HCOUNT is different. The value HMCOUNT = U5956123 appears three times and this value is counted three times.

CUSTO	HMCONT	PEV
CUSTO1	U5956123	1
CUSTO1	U5956123	1
CUSTO1	U5956123	1
CUSTO2	U3176658	1
CUSTO2	U3537855	1
CUSTO2	U9180451	1
CUSTO2	U9281210	1
CUSTO2	U2082308	1

see under the result

CUSTO		PEV
CUSTO1		3
CUSTO2		5

Column CUSTO and HMCOUNT have 30 000 rows with different value. How to do to count only once if the value appears several time, like sum product in Excel?

count(PEV)

[swuehl · Accepted solution]

try a distinct count

=count(distinct HMCONT)

[realpixel]

Hello Swuehl, thank you for your assistance. It's works!