SOLVED

# Creating a List from Another List using Criteria: Y/N

Copper Contributor

# Creating a List from Another List using Criteria: Y/N

Hello All,

Asking for some help please. Below I have a list example. My list is 150 PNs long. I need to create a list on another sheet in the same file which only shows PNs which have been validated with a "Y".

Keep in mind column "PN" is column A whereas column "Valid (Y/N) is all the way in column BB.

 PN Valid (Y/N) 123 N 456 Y ABC N DEF Y HIG Y 789 Y BHI N 321 N

Any help would be greatly appreciated !

2 Replies
best response confirmed by FrenchyFri27 (Copper Contributor)
Solution

# Re: Creating a List from Another List using Criteria: Y/N

=FILTER('Sheet 1'!A2:A200, 'Sheet 1'!BB2:BB200="Y", "")

Replace Sheet 1 with the name of the sheet with the source list.

# Re: Creating a List from Another List using Criteria: Y/N

Wow can't believe it was that easy. I've never used =Filter before. Thank you Hans!
1 best response

Accepted Solutions
best response confirmed by FrenchyFri27 (Copper Contributor)
Solution

# Re: Creating a List from Another List using Criteria: Y/N

=FILTER('Sheet 1'!A2:A200, 'Sheet 1'!BB2:BB200="Y", "")

Replace Sheet 1 with the name of the sheet with the source list.