Formula's not converting from Google Sheets

**TEN36VX** · 09-17-2019, 05:54 PM

I have a document with som complicated furmulation that I put onto Google Sheets to get some help remotely as I am out of my depth. The solution was found (arrays) but now when I download it to use back on Excel, it pops up with errors..
Heres the comparison formulas

Sheets: =(K13)/ArrayFormula(sum(n(mmult(sequence(1,rows($D$2:$D$9),1,0),($D$2:$J$9<>"") * (hlookup(B$2:B$9,$N$11:$U$22, (row()-10),false)<>""))>0)))
Excel: {=(K13)/SUM(N(MMULT(sequence(1,ROWS($D$2:$D$9),1,0),($D$2:$J$9<>"") * (HLOOKUP(B$2:B$9,$N$11:$U$22, (ROW()-10),FALSE)<>""))>0))}

I know Excel converts ArrayFormula() to {}, but other than that I'm at a loss...

**johnmpl** · 09-17-2019, 07:58 PM

Hi, TEN36VX!

The sequence function is not available in Excel 2010. Actually, is in Excel 365 Insider.

Then, you can replace:
sequence(1,ROWS($D$2:$D$9),1,0)

With this:
COLUMN($D$2:$K$2)^0

PD: If you have any troubles with the final formula, upload an excel sample file. Blessings!

**MrShorty** · 09-17-2019, 07:59 PM

You don't explain what errors you are getting. I note that the SEQUENCE() function in Excel appears to be one of those functions that MSFT is working on and is currently only available to select "Office Insiders" with the correct Office 365 subscription (https://support.office.com/en-us/art...4-2eb78519ca90 ). Your profile says that you are using Excel 2010. Assuming that is still correct, then I think you are going to need to either stick with Google sheets for this sheet, or you are going to need to develop an alternative to the SEQUENCE() function that works with your version of Excel.