My spreadsheet is set up like this:
Column A contains a list of names.
Column B contains a 'y' or 'n'
Column C contains a 'y' or 'n'
On sheet 2 I want a separate list to be created with only the names that have a 'y' in column B and a 'y' in column C to show up.
The function I have so far is below. 'A' designates the range in column A, 'B' for column B.
=IFERROR(INDEX(A, SMALL(IF(B<>"y", "", ROW(A)-MIN(ROW(A))+1), ROW(A1))),"")
This function creates a list with only the names that have a 'y' in column B. I don't know how to expand this formula to only take the names with 'y' in column C as well.
Help please? Thanks in advance.
Bookmarks