How to protect respondents confidentiality?

NorbertoG 

Thanks for reaching out. I've been thinking about it and after dynamic arrays hit Excel, I prefer not to use pivot tables but instead use pure calculations.

The functionality, to view results only if at least ten identities are in the selection, could start like this. 

=IF(ROWS(UNIQUE(RespondentsTable[ID]))<=10,"2few2view","{show result}")

One thing is that the table holds all the data all the time and you need to count the rows in the current selection.

Thus you have to filter the tables data to the wanted selection  and count the rows in the filtered result, eg in cell M2 and thus replace the full set of RespondentsTable[ID]'s with M2#.

So far, it's a question of Excel functionality and I have attached a file that uses slicers to filter a table - not just hide rows outside the scope.

It's both all in one (g24) and splitted into different parts (columns M to Z).

A bigger issue is to distribute Excel files with confidential data.

From my point of view, Excel is not at all secure enough and I would not do it. If it had to be Excel, I would make the raw data anonymous eg by replacing sensitive information with a not related numbers.

The example data in the file is GDPR fines for some first years. Not taking care of confidential data may come costsome.