+ Reply to Thread
Results 1 to 5 of 5

Is Query function of Google spreadsheet like available in MS Excel

  1. #1
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2021 / 365
    Posts
    1,248

    Is Query function of Google spreadsheet like available in MS Excel

    Hi,

    I have also been using google spreadsheet for a while.I am pretty impressed by Query function for e.g-

    =Query (Range,"select B,D,K sum (E) where M='Power' order by B",1)

    Is such type available in Power Query or somewhere in MS Excel.

  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
    80,779

    Re: Is Query function of Google spreadsheet like available in MS Excel

    Please clarify: is this a Google Sheets query?
    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
    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,779

    Re: Is Query function of Google spreadsheet like available in MS Excel

    Please answer my question.

  4. #4
    Forum Contributor
    Join Date
    03-11-2011
    Location
    Nepal
    MS-Off Ver
    MS Excel 2021 / 365
    Posts
    1,248

    Re: Is Query function of Google spreadsheet like available in MS Excel

    Yes, Mam.I don't know whether similar is available in ms excel or not.

  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
    80,779

    Re: Is Query function of Google spreadsheet like available in MS Excel

    Google Sheets questions belong in the Other Platforms section. Thread moved.

+ 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. Google Sheets query function replacement
    By Ollie Frith in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-09-2019, 05:41 PM
  2. Google Sheets QUERY How can I do the same in Excel?
    By Ziggy21 in forum Excel General
    Replies: 12
    Last Post: 10-04-2015, 07:54 PM
  3. Google Sheets Query IF column problem Converted to Excel Function?
    By Garthilk in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-24-2015, 10:37 PM
  4. "FILTER" equivalent function of google spreadsheet in Excel
    By excelismagic in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-03-2015, 08:22 AM
  5. [SOLVED] Modifying a Lat/Long function to extract ID and Reference from a Google Place query
    By Eagle29 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2013, 05:51 AM
  6. google spreadsheet need function/code to pull data from one sheet to another
    By venusrena in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 04-27-2013, 04:48 AM
  7. 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

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