Ok, Excel question....
I've got a 13000 row spreadsheet. Each row is a unique 'incident' in our school.
Each incident (row) can have up to 5 'action codes' entered...these are 5 different columns (CODE1, CODE2, etc)
There are 9 possible action codes (ESU1 - ESU9)
So I need to look across 5 different columns and then I want to filter out ANY row that does NOT have an action code of ESU1 - ESU9
This will leave me with only incidents that involved a suspension.
I need some help in how to filter across multiple columns.
Hope this is clear.
Thanks a bunch.