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
Bookmarks