+ Reply to Thread
Results 1 to 1 of 1

Query function from google docs in excel 2011, anyone with a solution?

  1. #1
    Registered User
    Join Date
    11-12-2012
    Location
    Gothenburg
    MS-Off Ver
    Excel 2011
    Posts
    2

    Query function from google docs in excel 2011, anyone with a solution?

    Hello everyone!

    I have converted a google docs spreadsheet to excel because the document updated to slow...

    But one of my central functions did not survive the conversion

    I have used the following formula in google docs and I would like to find something that creates the same solution
    " =query('hantering kunder'!A2:E5581, "select A, B, C where E <> 'VISA EJ' and A <> '' order by A asc")"

    hantering kunder'!A2:E5581: Shows the range that i want create a list form.

    select A, B, C where E <> 'VISA EJ' and A <> '' order by A asc": This part says that I want the function to choose collums A, B and C in the range "hantering kunder'!A2:E5581" if column E dosen't contain "VISA EJ" and column A is not blank, and then I want the list to be sorted in assending order.

    Does anyone have a simple solution for excel that would do the same thing?

    I have attatched the document, the list is supposed to be created in the sheet "Lista Aktuella kunder"

    With best regards
    Emil Eriksson Katz
    Attached Files Attached Files

+ 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