josvill2010
New Member
- Joined
- Jun 1, 2011
- Messages
- 40
- Office Version
- 365
Hi, I have this formula that works well to bring the data from EAST but I also would like to bring the data from WEST.
I want to avoid bringing North, South.
What do I need to do to the formula to get it working to include WEST and EAST?
This is the formula
=filter(importrange("Google Sheets: Sign-in", "Spend !A:U"),index(importrange("Google Sheets: Sign-in", "Spend!A:U"),0,1)="EAST")
I want to avoid bringing North, South.
What do I need to do to the formula to get it working to include WEST and EAST?
This is the formula
=filter(importrange("Google Sheets: Sign-in", "Spend !A:U"),index(importrange("Google Sheets: Sign-in", "Spend!A:U"),0,1)="EAST")