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.

Daily Tips For Your Phone

Get the Gadget Hacks newsletter for new tips every day.

Be the First to Respond

Share Your Thoughts