Say I have a list of people's names in one column, and their age in another.
I would like to have a separate cell display a list of all the names that are above a certain age.
For instance:
John = 23
James = 25
Maria = 40
Mike = 18
Jonas = 65
I would like a cell displaying all names of people over 24.
so it would list:
James, Maria, Jonas
Last edited by anthonydebenedet; 10-23-2018 at 03:17 PM.
If using Office 365...
Assuming data in A2:B6 range. A column with names, B with age.
Formula:
Please Login or Register to view this content.
Confirmed as array function (CTRL + SHIFT + ENTER)
"Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something."
― Robert A. Heinlein
Perfect, Thank you.
You are welcomeIf this solved your issue, please mark the thread as solved, using thread tool found at top of your initial post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks