Count if Value only appears once

[jamesehunt]

Hello,

I need to Count values in one column but only if the value appears once. As well as values which appear more then once and how many duplicates.

9002216

9002217

9002218

9002218

9002218

9002219

e.g.

values appearing once: 3

values appearing more than once: 1

duplicates appearing: 3

Thanks for helping

[sunny_talwar · Accepted solution]

Value appearing one

Count(DISTINCT{<Value = {"=Count(Value) = 1"}>}Value)

Value appearing more than once

Count(DISTINCT {<Value = {"=Count(Value) > 1"}>}Value)

Duplicate appearing

Count({<Value = {"=Count(Value) > 1"}>}Value)

[jamesehunt]

Hello Sunny,

thank you very much.

Would anyone be so kind and help me with the following :

sum full pallets if value appearing more than once

sumd full pallets if value appearing only once

Thank you very much for your help

[sunny_talwar]

May be this

sumd full pallets if value appearing only once

Sum({<Value = {"=Count(Value) = 1"}>} [full pallets])

sum full pallets if value appearing more than once

Sum({<Value = {"=Count(Value) > 1"}>} [full pallets])

[jamesehunt]

Thank you. Worked perfectly