Unique Values From Different Areas BUT with criteria

[ellison]

Hi, we are trying to make a unique list from separate columns of a spreadsheet BUT taking into account the criteria (y/n) columns...

Sitrep so far:
-A unique set of values from different columns on a spreadsheet: done
-Taking into account blanks: done
-Sorted A-Z: done
The formula we are using for this is:

#=SORT(UNIQUE(TOCOL((B2:B10, D2:D10,F2:F10), 1)))

But we are also trying to make the formula take into account the accompanying info (Y/N) in the criteria columns and can't do it.
Is this possible?
Please could you take a look at the below?

Row	Header-1	Use-Header-1	Header-2	Use-Header-2	Header-3	Use-Header-3		#=SORT(UNIQUE(TOCOL((B2:B10, D2:D10,F2:F10), 1)))	My Manual Notes
2	South	y	alpha	n	football	y		alpha	no, should not be included
3	North	n	echo	y				beta	no, should not be included
4	East	y			rugby	n		charlie
5	North	n	echo	y				cricket	no, should not be included
6	East	y			cricket	n		East
7	North	n	beta	n				echo
8	West	y	charlie	y	netball	y		football
9	South	y	alpha	n				netball
10	South	y	alpha	n				North	no, should not be included
								rugby	no, should not be included
								South
								West

Huge thanks for taking a look!

 

[ISY]

Hi

=UNIQUE(SORT(A.COL(IF(C2:G10="Y",B2:F10,x),3)))

 

[ellison]

Hi

=UNIQUE(SORT(A.COL(IF(C2:G10="Y",B2:F10,x),3)))

Sorry but I get error message when I enter that: #NAME?

 

[ISY]

Hi

=UNIQUE(SORT(TOCOL(IF(C2:G10="Y",B2:F10,x),3)))

 

[ellison]

BOOM absolutely wonderful, huge thanks!!