Hi All
I have a group of Users who have to enter student rosters into a separate program based on a spreadsheet which shows student placements/ locations
They are finding the student placement roster hard to read . Is it possible to apply advanced filters to this sheet
Ideally it would be great have multiple filtering criteria along the top so that as date range could be selected , or a group , or a placement location such as "ÄDH""CAN"with a date range. Looking at multiple criteria if possible
Then show this data under the search criteria
I don't think that the Uni could have produced anything more complicated than this . Is just really hard to read especially when you have to input rosters into another program based on the students location
I have done some research and though advanced filters by multiple criteria would work.
I hope someone will take up the challenge . I dont know enough about filtering to know if this is the best solution
Any assistance gratefully received
PS I only have excel
I have a group of Users who have to enter student rosters into a separate program based on a spreadsheet which shows student placements/ locations
They are finding the student placement roster hard to read . Is it possible to apply advanced filters to this sheet
Ideally it would be great have multiple filtering criteria along the top so that as date range could be selected , or a group , or a placement location such as "ÄDH""CAN"with a date range. Looking at multiple criteria if possible
Then show this data under the search criteria
I don't think that the Uni could have produced anything more complicated than this . Is just really hard to read especially when you have to input rosters into another program based on the students location
I have done some research and though advanced filters by multiple criteria would work.
I hope someone will take up the challenge . I dont know enough about filtering to know if this is the best solution
Any assistance gratefully received
PS I only have excel