Forum Discussion
Can't Export Google Sheets to Excel
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 Goog...
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))),"")
=IFERROR(sort(unique(VLOOKUP(A:A,B:B,1,FALSE))),"")