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
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