Can't Export Google Sheets to Excel

Copper Contributor
 

I am trying to import a google sheets file to excel,  but my formulas are not translating.

I know arrayformula does not work with Excel, but I cannot find the equivalent.

 

My formula in Google Sheets is   =IFERROR(sort(unique(arrayformula(VLOOKUP(A1:A,B1:B,1,FALSE)))),"")

 

What is showing up in Excel is =IFERROR(@__xludf.DUMMYFUNCTION("IFERROR(sort(unique(arrayformula(VLOOKUP(A1:A1442,B1:B1442,1,FALSE)))),"""")"),"Both")

 

Thank You in advance!

 

2 Replies
Array functionality is in Excel 365 so just drop "arrayformula" and try again. Should be something like:
=IFERROR(sort(unique(VLOOKUP(A:A,B:B,1,FALSE))),"")

@user_1214 

As variant that could be

=SORT( UNIQUE( FILTER(B1:B1442, COUNTIF(A1:A1442,B1:B1442) ) ) )

VLOOKUP() is not the best option working with dynamic arrays