Mar 16 2021 02:04 PM
Hello,
I have three columns of data, name, gender and age. In a separate cell, I want to call show a name based on conditions on certain age and gender. For instance showing me the name of the person (in the new cell) who is 50 years old and is a Female. Having said that, I have repeatition in my list, how do I do that without having to worry about repeatition?
Second senario is the same as above but this time I want to call names of people who satisfy a certain age range (e.g. between 40 - 50 years old) and are Female. Again not having repeatition.
Thanks in advance for the help.
Ali
Mar 16 2021 02:19 PM
Depends on version of Excel you use.
As variant, you may have 3 cells, with drop-down lists if desired, for min age, max age and gender. Based on them you FILTER() the names and wrap result by TEXTJOIN() for the case if more than one of such names.
Mar 16 2021 02:23 PM
Mar 16 2021 02:36 PM
SolutionMar 16 2021 03:03 PM
Mar 17 2021 07:30 AM
You are welcome, glad it helped
Mar 16 2021 02:36 PM
Solution