Alternative formula to work in Excel 2013

[ashani]

Hi,
The following formula works in Office 365 but doesn't work in Excel 2013 - please can someone guide me the alternative to this formula that can work in Excel 2013.

=IFERROR(UNIQUE(FILTER('Test'!BK1:BK10000, 'Test'!BK1:BK10000<>"")),"")

Thank you

 

[Domenic]

Try...

ashani.xlsm
	BK	BL	BM	BN
1	List		Unique Count	Result
2	B		3	A
3				B
4	C			C
5	A
6
7	B
8	A
9
10	C
Sheet1

Cell Formulas
Range	Formula
BM2	BM2	=SUM(IF(FREQUENCY(IF(LEN(BK2:BK10)>0,MATCH(BK2:BK10,BK2:BK10,0)),ROW(BK2:BK10)-ROW(BK2)+1)>0,1))
BN2:BN10	BN2	=IF(ROWS($BN$2:BN2)<=$BM$2,INDEX($BK$2:$BK$10,MATCH(SMALL(IF(LEN($BK$2:$BK$10)>0,IF(ISNA(MATCH($BK$2:$BK$10,$BN$1:BN1,0)),COUNTIF($BK$2:$BK$10,"<"&$BK$2:$BK$10))),1),IF(LEN($BK$2:$BK$10)>0,COUNTIF($BK$2:$BK$10,"<"&$BK$2:$BK$10)),0)),"")
Press CTRL+SHIFT+ENTER to enter array formulas.

Hope this helps!