Nov 19 2021 11:21 AM
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!
Nov 19 2021 11:44 AM
Nov 19 2021 12:03 PM
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