Formula COUNT(DISTINCT(COLLECT

Natalia Szarecka

Does the formula COUNT(DISTINCT(COLLECT work when cells are linked to another sheet? I use =COUNT(DISTINCT(COLLECT({Range 6}, {Range 7} = "import"))). It counts unique values in a sheet without linked cells and does not work with the linked ones. Could you help?

Paul Newcome

It should work with the linked cells. Are you able to provide more details and possibly some screenshots of the source data?

Paul Newcome

It should work with the linked cells. Are you able to provide more details and possibly some screenshots of the source data?

Natalia Szarecka

Hey Paul,

Thanks for quick reply. Actually, I solved the issue on my own. Thanks :) Have a great day!