Only show name if added to other list

[sofiachr]

Hi!

I have a file where my coworkers need to add them self for transport to an event. They can either add them self as drivers (column A) and allow others to fill in their names at the passenger seats (column E:H), or they can add them self as a passenger on a row where someone else are named driver. To the right of this table I have a list of everyones names representing who haven´t yet added themself somewhere in the list. I want this name to disappear and show nothing ("") when added to the list.

So, if my coworker Sandra is adding her self as a driver or a passenger to the list, any cells in the table of A6:H29, her name in my list of "not yet signed up" will disappear.

How can I use a formula to do this?

Regards,
Sofia

 

[Skovgaard]

Hi Sofia,

You can use Conditional Formatting to color the names white, so they looks like they are disappeared.
If you have the first name in cell K2, you can use below formula as a rule.

=IF(COUNTIF(A:H,K2)>0,TRUE,FALSE)

/Skovgaard

 

[Joe4]

Hi Sofia,

You can use Conditional Formatting to color the names white, so they looks like they are disappeared.
If you have the first name in cell K2, you can use below formula as a rule.

=IF(COUNTIF(A:H,K2)>0,TRUE,FALSE)

/Skovgaard

The IF function is redundant and unnecessary. Since the Conditional Formatting formula is just looking for a boolean (TRUE/FALSE) value, you can get that with just your inequality, i.e.

=COUNTIF(A:H,K2)>0