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