+ Reply to Thread
Results 1 to 8 of 8

Convert Google sheets formulae to excel

  1. #1
    Registered User
    Join Date
    12-28-2020
    Location
    ADELAIDE, SOUTH AUSTRALIA
    MS-Off Ver
    VERSION 16.44 (MAC)
    Posts
    5

    Convert Google sheets formulae to excel

    Trying to replicate a Google Sheets spreadsheet into Excel but can not as the formulae doesn't exist in Excel.
    Any ideas how to achieve the same thing would be appreciated

    =IF($B7="SELL",MIN(ARRAYFORMULA(IF(FILTER($L$3:$L7,$A$3:A7=A7)>=-SUMIFS(C$3:C7,A$3:A7,A7,B$3:B7,"SELL"),FILTER($F$3:$F7,$A$3:A7=A7)))),)

    The Spreadsheet is quite complex and that particular line checks for a date when a particular Crypto that has been sold was bought.
    As cryptos are bought and sold they are disposed of in a First In First Out basis and the spreadsheet keeps information on this and adjusts accordingly.

    Thank You

    Screen Shot 2020-12-28 at 3.16.32 pm.png
    Last edited by TH1963; 12-28-2020 at 12:50 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Convert Google sheets formulae to excel

    Administrative note

    Welcome to the forum

    in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

  3. #3
    Registered User
    Join Date
    12-28-2020
    Location
    ADELAIDE, SOUTH AUSTRALIA
    MS-Off Ver
    VERSION 16.44 (MAC)
    Posts
    5

    Re: Convert Google sheets formulae to excel

    Impossible to share a google sheet as i'm not allowed to at the moment.

    When I download the file it saves it as an excel sheet and changes all the formulae to errors.

    So there is not much I can do at the moment.....

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,778

    Re: Convert Google sheets formulae to excel

    You can get round this by adding a space or two to the URL - try that.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Registered User
    Join Date
    12-28-2020
    Location
    ADELAIDE, SOUTH AUSTRALIA
    MS-Off Ver
    VERSION 16.44 (MAC)
    Posts
    5

    Re: Convert Google sheets formulae to excel

    Tried adding spaces but still the same error message:

    You are not allowed to post any kinds of links, images or videos until you post a few times.

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,778

    Re: Convert Google sheets formulae to excel

    It's a case of getting the spaces in the right place.

    Try again.

    Mods don't ask you to do things we know you can't do!

  7. #7
    Registered User
    Join Date
    12-28-2020
    Location
    ADELAIDE, SOUTH AUSTRALIA
    MS-Off Ver
    VERSION 16.44 (MAC)
    Posts
    5

    Re: Convert Google sheets formulae to excel

    Link to workbook: https://docs.google.com/spreadsheets...it?usp=sharing

    Mod Edit: link recomposed.

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,778

    Re: Convert Google sheets formulae to excel

    There you go!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to convert Google Script to Excel Macro?
    By cestanton.1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2020, 05:28 PM
  2. Google Apps Script for Google Sheets Pulling Formulas from Master to Several Slave Sheets
    By excelroofing in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 4
    Last Post: 08-22-2018, 02:06 AM
  3. How do I convert an INDEX SMALL array formula for use in Google Sheets?
    By sharadmaxwell in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 7
    Last Post: 07-25-2018, 08:40 AM
  4. email row contents based on cell values (google sheets populated by google forms)
    By reedg in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 01-13-2016, 02:55 PM
  5. Convert Google sheet into Excel
    By Sailaja A in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-29-2015, 03:07 AM
  6. Replies: 0
    Last Post: 02-14-2013, 06:56 AM

Tags for this Thread

Bookmarks

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