=COUNT(DISTINCT(COLLECT

ShaunW

Hi,

i am using the "DISTINCT" value in a formula which works great however is there a way to not count entries twice based on if its submitted as capital or lower case, for instance 'Fred' & 'fred' are counted as two unique names when in fact i only want it counted once?

Cheers

Shaun

Paul Newcome

You'll need a helper column that converts every row into either UPPER or LOWER and then pull your count from there.