Forum Thread: Filtering/Sorting Text Data in Numbers to New Sheets

I am a primary PE teacher. I am attempting to set up a template to automatically set up class lists, attendance lists and options they have chosen.

I begin with a table of all students; names, class, year level, DOB, etc. Currently I sort by, for example, class, then I will cut and paste this class into a new sheet. I would like to make this an automatic step so that when I receive the list, the spreadsheet will automatically produce the class list in a separate sheet for me, with all the data listed above.

I think once I know the formula/step that I need to achieve this, I can repeat this for a range of other filters that I need to run.

I have attempted Vlookup and HLookup but I couldn't get them to work.

Any assistance would be appreciated.

Thanks.

Be the First to Respond

Share Your Thoughts