# Formula's not converting from Google Sheets

1. ## Formula's not converting from Google Sheets

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

2. ## Re: Formula's not converting from Google Sheets

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!

3. ## Re: Formula's not converting from Google Sheets

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.

#### Thread Information

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1