Excel Chimp
Board Regular
- Joined
- Oct 30, 2008
- Messages
- 90
Hi folks. I have a table with about 52 fields, columns A thru EV.
What I'd like to do is do an advanced filter like: If column D="O" AND (column I is blank OR column N is blank OR column BD is blank) then display the record.
I'm a pivot table novice. I'm not sure if I'm making this more complex than need be. Maybe I just need to apply an advanced filter and there is no need for a pivot table?
Thanks.
What I'd like to do is do an advanced filter like: If column D="O" AND (column I is blank OR column N is blank OR column BD is blank) then display the record.
I'm a pivot table novice. I'm not sure if I'm making this more complex than need be. Maybe I just need to apply an advanced filter and there is no need for a pivot table?
Thanks.