Challenge #286: Who turned the lights off?

[ahmedirfanp]

My Solution for this Challenge. 

[Erin]

Spoiler

[danespoors]

Took me quite a while annoyingly. I never think of using the find and replace tool.

[SgdPackard810]

Shoutout @Aaron_Harter for a little reminder of the find + replace tool. Messed around with a cross-tab and IN operator within the formula tool for waayyy too long trying to get this. Elegant solution you had there that helped me get the exact configuration I was seeking!

[Rupal03]

Awesome challenge 🙂

My Solution is here :

[DaisyJones]

Here is my solution

Spoiler

 

[alishadhillon__]

I definitely don't use the Find and Replace tool enough and so this was a good way to practice and attempt playing around with the configuration until I got my desired result. Really good challenge!

 

[JosephSerpis]

Challenge Completed

Spoiler

[ehughes]

Spoiler

[SunderlandHughes]

Spoiler