Display data from other cells/sheets with conditions

Occasional Contributor

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 
Stock D 

Looking forward to hearing from you soon. 

Thank you. 

3 Replies
best response confirmed by Sergei Baklan (MVP)


As 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.

FILTER function

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.



I know I don't know anything (Socrates)


Was the answer useful? Mark them as helpful!

This will help all forum participants.

@NikolinoDE thank you so much! It solved my problem finally!
I am glad that you can solve your problem.

Furthermore, I wish you much success with Excel.