Nov 11 2021 09:58 PM
Hey guys, I am new to this community! Nice to meet you all here.
I am facing a problem whereby I have a list of items with either yes or no options (as shown below),
Stock A Yes
Stock B No
Stock C No
Stock D Yes
Then I would like to have those stocks with "Yes" being display in another sheet/cells like this (as shown below),
Stock A
Stock D
Anyone knows how to set the formula in this case? I have tried IF formula, however, it will have blank instead if the stocks is with "No" (as shown below)
Stock A
(blank)
(blank)
Stock D
Looking forward to hearing from you soon.
Thank you.
Nov 11 2021 11:14 PM
SolutionAs for Mac, my knowledge is (to put it mildly) very limited.
But filters should also work with Mac.
Here is an example file with table filter.
The FILTER function allows you to filter a range of data based on criteria you define.
Hope I was able to help you with this info.
NikolinoDE
I know I don't know anything (Socrates)
Was the answer useful? Mark them as helpful!
This will help all forum participants.
Nov 17 2021 07:15 PM
Nov 17 2021 08:43 PM
Nov 11 2021 11:14 PM
SolutionAs for Mac, my knowledge is (to put it mildly) very limited.
But filters should also work with Mac.
Here is an example file with table filter.
The FILTER function allows you to filter a range of data based on criteria you define.
Hope I was able to help you with this info.
NikolinoDE
I know I don't know anything (Socrates)
Was the answer useful? Mark them as helpful!
This will help all forum participants.