Forum Discussion
Solved
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 !
=FILTER('Sheet 1'!A2:A200, 'Sheet 1'!BB2:BB200="Y", "")
Replace Sheet 1 with the name of the sheet with the source list.
=FILTER('Sheet 1'!A2:A200, 'Sheet 1'!BB2:BB200="Y", "")
Replace Sheet 1 with the name of the sheet with the source list.
- Wow can't believe it was that easy. I've never used =Filter before. Thank you Hans!
