Bonjour!
I am trying to create a sheet for a report we use to locate vehicles. We have the list, but would like to exclude 2 items from a certain column. I have looked up formulas, but the only one I can find is:
=FILTER(IMPORTRANGE(“Google Sheets - create and edit spreadsheets online, for free. LIST!B:D”), INDEX(IMPORTRANGE(“Google Sheets - create and edit spreadsheets online, for free. LIST!B:D”),0,D)=”Groceries”)
This is only an example, but this only pulls through the items that have "Groceries" in Col D. I would use this, but the items I want it to pull through total upto 1240 out of 1242. Its the additional 2 I dont want pulled through. These would be "GWS" and "GWSIN" for reference. Otherwise I would have to put in 1240 entries which im not sure if would crash the formula, but also take ages when I only want to ignore 2 results.
Any help would be much appreciated.
Thanks,
Dan
I am trying to create a sheet for a report we use to locate vehicles. We have the list, but would like to exclude 2 items from a certain column. I have looked up formulas, but the only one I can find is:
=FILTER(IMPORTRANGE(“Google Sheets - create and edit spreadsheets online, for free. LIST!B:D”), INDEX(IMPORTRANGE(“Google Sheets - create and edit spreadsheets online, for free. LIST!B:D”),0,D)=”Groceries”)
This is only an example, but this only pulls through the items that have "Groceries" in Col D. I would use this, but the items I want it to pull through total upto 1240 out of 1242. Its the additional 2 I dont want pulled through. These would be "GWS" and "GWSIN" for reference. Otherwise I would have to put in 1240 entries which im not sure if would crash the formula, but also take ages when I only want to ignore 2 results.
Any help would be much appreciated.
Thanks,
Dan
