+ Reply to Thread
Results 1 to 5 of 5

Converting spreadsheets from Microsoft Excel to Google Docs

  1. #1
    Registered User
    Join Date
    09-26-2011
    Location
    Missouri, America
    MS-Off Ver
    Excel 2021
    Posts
    32

    Converting spreadsheets from Microsoft Excel to Google Docs

    I am in the process of converting all of my Microsoft Excel spreadsheets to Google Docs. However I have one formula that is giving me trouble. I don't know if it is called a range formula or and array formula but I cannot get it to work right in Google Docs. Can anyone help me accomplish this? Here is the formula:

    =LOOKUP(1E+100,FREQUENCY(IF(A3:A22=BK2,ROW(A3:A22)),IF(A3:A22<>BK2,IF(A3:A22<>"",ROW(A3:A22)))))&" "&BK2

    I use it to track the Wins and Losses Streak for football games that are listed in a list from A3 to A22

    The formula also references another formula located at BK2 and that formula is:

    =LOOKUP(2,1/(A3:A22<>""),A3:A22)

    I am attaching a sample spreadsheet. Like I said I am very very stumped on this. I have done everything I can think of and have had no success.Week Progress-2013.xls

  2. #2
    Registered User
    Join Date
    10-01-2013
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    5

    Re: Converting spreadsheets from Microsoft Excel to Google Docs

    Hi,

    Go to Google docs home page, click on upload and click on File, then browse and select the file on your system drive that you want to upload and finally choose to convert your file to Google Docs format.

    Hope it helps...


    Thanks!

  3. #3
    Registered User
    Join Date
    09-26-2011
    Location
    Missouri, America
    MS-Off Ver
    Excel 2021
    Posts
    32

    Re: Converting spreadsheets from Microsoft Excel to Google Docs

    I have already tried that. It does not even attempt to convert that formula. The other formulas on the spreadsheet convert just fine.

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Converting spreadsheets from Microsoft Excel to Google Docs

    You might have more success on a Google Docs forum.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    09-26-2011
    Location
    Missouri, America
    MS-Off Ver
    Excel 2021
    Posts
    32

    Re: Converting spreadsheets from Microsoft Excel to Google Docs

    i did not think of that. doing it now.

+ 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. Query function from google docs in excel 2011, anyone with a solution?
    By emilero in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-12-2012, 04:04 PM
  2. Uploading Excel Spreadsheet to Google Docs
    By Jakub in forum Excel General
    Replies: 0
    Last Post: 02-13-2012, 06:35 PM
  3. Filter command from Google Docs not working on Excel
    By sakau2007 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-03-2010, 12:07 PM
  4. Google Docs/Excel - Percentage converts to Decimal
    By bugmenot in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 03-08-2010, 04:52 PM
  5. [SOLVED] converting excel docs to word docs
    By rolercster in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 01-04-2005, 04:06 PM

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