Hide other duplicates using cond formatting + IF function based on x in adjacent cell

[mikelee147]

Hi All,

I'm working on a personnel deployment tool, which gives me a list of names under specific work areas. However, some operatives are qualified to work in more than one area. Therefore I'm trying to develop a tool which I can use to select a name in any one list (by putting an 'x' in the cell next to it), but hide all other instances of it in the other lists.

There may be more than one instance of a duplicated name, so this functionality needs to work for each different duplicated name.

I have tried to figure this out, but I can only figure the constituent parts to this. The =COUNTIF($A$1:$A1, A1)>1 function highlights duplicates. I can use conditional formatting to make the text white, effectively hiding it. And I can use the IF function to recognise an adjacent cell, and perform an action based on it.

It's my first post in this forum. I welcome your help and advice. Thank you.


Attachment: "personnel assignment example"

[AliGW]

Welcome to the forum.

In the sample workbook, can you please add a second instance of the table showing us how you want it to look once you have added the x marks?

[mikelee147]

Hi Ali
I've edited the original attachment. Thank you!
Mike

[AliGW]

Thanks! Will have a think ...