I have some data from workplaces with some different work areas, I need to extract a list for each workplace with their corresponding availables working areas, I have an example of some kind of attempt really close what I wanted. I use this formula but with more data will be long time to do it
=IF(D2=$G$1, "Yes", "No"). I want to do it more automatic with some formulas but I don’t know where to start.
Give a try on below formula. Put the formula to
G1 cell then drag down as needed.
Answered By – Harun24hr
Answer Checked By – Gilberto Lyons (AngularFixing Admin)