+ 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
    113

    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
    2010
    Posts
    1,424

    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
    UK
    MS-Off Ver
    2010 primarily
    Posts
    3,281

    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
    Days when we raged, we flew off the page
    Such damage was done

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

    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)

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