+ Reply to Thread
Results 1 to 4 of 4

How to select multiple columns in query function.

  1. #1
    Forum Contributor
    Join Date
    08-07-2018
    Location
    india
    MS-Off Ver
    2007
    Posts
    233

    How to select multiple columns in query function.

    HI EVERYONE,
    i have a task sheet. in sheet admin i have applied query function in cell A3. my problem is that i have to select data from colum A to column MJ. and for that i will have to type every column name as you can check in the formula applied in cell A3. i have typed select column A, B, C,........AK. so i want that if there is any other solution so that i can apply that like select A:MJ.

    so please check the formula and please find a shortcut so that i can get rid from typing every column name. here is the link of file https://docs.google.com/spreadsheets...t#gid=70532262

  2. #2
    Forum Expert
    Join Date
    10-10-2016
    Location
    Sheffield
    MS-Off Ver
    365 and rarely 2016
    Posts
    3,198

    Re: How to select multiple columns in query function.

    What do you want to do? I can see a query formula, but am unsure what you want to accomplish. What is the result in the cell A3 if the formula did what you wanted and why?

  3. #3
    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 select multiple columns in query function.

    If you want all the columns back, use something like:

    Please Login or Register  to view this content.
    Rory

  4. #4
    Forum Contributor
    Join Date
    08-07-2018
    Location
    india
    MS-Off Ver
    2007
    Posts
    233

    Re: How to select multiple columns in query function.

    thanks a lot. i really happy to see the formula and it has saved me from typing too much column numbers. i really appreciate. and how fast responsive you are. just got my answer in few hours. this is called a true expert. again thanks a lot

+ 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. [SOLVED] Power Query ranking multiple columns
    By rs1aj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-26-2019, 11:43 PM
  2. Passing Multiple Values To Query With Multi Select Box
    By Excel4444 in forum Access Tables & Databases
    Replies: 0
    Last Post: 07-18-2016, 02:47 PM
  3. Checking multiple criteria and select data over multiple columns
    By jy677 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-25-2013, 09:38 PM
  4. Multiple dropdown select (multiple columns)
    By maxthebear in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-04-2009, 06:08 PM
  5. How to select multiple columns
    By Dave32 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-02-2008, 10:53 AM
  6. [SOLVED] Excel MS Query multiple select statements
    By Revenger in forum Excel General
    Replies: 3
    Last Post: 05-12-2006, 07:40 AM
  7. MS query return multiple columns in Excel
    By normajmarsh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-13-2006, 04:55 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