+ Reply to Thread
Results 1 to 8 of 8

How do I convert an INDEX SMALL array formula for use in Google Sheets?

  1. #1
    Registered User
    Join Date
    04-27-2016
    Location
    india
    MS-Off Ver
    2007
    Posts
    87

    How do I convert an INDEX SMALL array formula for use in Google Sheets?

    i attached herwith the excel file
    where in Sheet1 contain my main data
    and in sheet2 i used forumulas
    in sheet2
    colum A3
    i used below Arrary forumla
    =IFERROR(INDEX(Sheet1!F$2:F$1000,SMALL(IF(Sheet1!$A$2:$A$1000=Sheet2!$A$1,ROW(Sheet1!$A$2:$A$1000)-ROW($A$2)+1,""),ROWS($A$2:A2))),"")

    now
    i want same formula but in GOOGLE SHEET
    i dont know how to apply this on Google Sheet
    please help me
    same in google sheet1 and sheet2
    Attached Files Attached Files
    Last edited by sharadmaxwell; 07-24-2018 at 02:03 AM. Reason: change title

  2. #2
    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
    79,369

    Re: need formula in Google Sheet

    Welcome to the forum! Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

    In your case, you need to give an indication of the type of formula you are trying to convert in your title.
    This thread has been moved to the correct section.

    To change a title go to your first post, click EDIT then Go Advanced and change your title.

    No help to be offered, please, until the OP complies with this request.
    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.

  3. #3
    Registered User
    Join Date
    04-27-2016
    Location
    india
    MS-Off Ver
    2007
    Posts
    87

    Re: need formula in Google Sheet

    done
    please guide

  4. #4
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,885

    Re: how to convert excel sheet forumla to Google Sheet formula

    It's actually much simpler in Google sheets. Clear out all the formulas returning data on sheet 2, then in A3 enter:

    =filter(Sheet1!$F$2:$I$1000,Sheet1!$A$2:$A$1000=$A$1)

    That is all.

  5. #5
    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
    79,369

    Re: how to convert excel sheet forumla to Google Sheet formula

    No, sorry - still not good enough. You didn't pay attention to my advice.

    Try changing the title to this: "How do I convert an INDEX SMALL array formula for use in Google Sheets?"

  6. #6
    Registered User
    Join Date
    04-27-2016
    Location
    india
    MS-Off Ver
    2007
    Posts
    87

    Re: how to convert excel sheet forumla to Google Sheet formula

    done mam
    please guide

  7. #7
    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
    79,369

    Re: How do I convert an INDEX SMALL array formula for use in Google Sheets?

    Thank you - that's fine now.

  8. #8
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: How do I convert an INDEX SMALL array formula for use in Google Sheets?

    rorya's post has been restored, thanks for the title change
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Synchronize multiple users one particular excel work sheet in google sheet?
    By bala04msw in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-07-2018, 04:22 AM
  2. Google Sheet formula
    By rizmomin in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-31-2017, 05:34 PM
  3. Is there a version of google sheet's IMAGE formula?
    By ammartino44 in forum Excel General
    Replies: 1
    Last Post: 10-03-2017, 09:30 PM
  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. VBA Route Calculator - Google Maps Api 22 Minutes quicker than Actual Google Website
    By lookingforhelp1 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-06-2015, 01:23 PM
  6. Google Drive Sheet - Simple Formula Help
    By dennybot in forum Excel General
    Replies: 1
    Last Post: 09-29-2012, 04:58 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