Forum Discussion
user_1214
Nov 19, 2021Copper Contributor
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...
SergeiBaklan
Nov 19, 2021Diamond Contributor
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