lizmorton1990
New Member
- Joined
- Aug 19, 2020
- Messages
- 16
- Office Version
- 2013
- Platform
- Windows
Hi,
I am trying to add an import range to pull any data in column D that starts with 'commercial'. At the moment I have this:
=query(importrange("https://docs.google.com/spreadsheet...jbostw7EwQqb6Z6LSQj27GqxA/edit#gid=1242623246", "Pivot Table 4!a:d"), "Select * Where Col4 ='Commercial'")
But I know this won't work as quite a few of the rows in column D have text after commercial i.e Commercial Driver
Is it possible to add 'starts with' and if so how do I do that?
I am trying to add an import range to pull any data in column D that starts with 'commercial'. At the moment I have this:
=query(importrange("https://docs.google.com/spreadsheet...jbostw7EwQqb6Z6LSQj27GqxA/edit#gid=1242623246", "Pivot Table 4!a:d"), "Select * Where Col4 ='Commercial'")
But I know this won't work as quite a few of the rows in column D have text after commercial i.e Commercial Driver
Is it possible to add 'starts with' and if so how do I do that?