How do I create automatically updated lists?

I have a list of names of first, second, and third graders. The first names are in Column A, the last names in Column B, and the grade in Column C.

I want Excel to create three separate class lists automatically (hopefully alphabetized), one class list for first graders, another for second graders, and another for third graders. I want to be able to add and delete names from the first list (the one with all of the names) and have Excel update the class lists automatically. The attachment shows how I want the finished product to look. Of course, I want to be able to enter data only in Columns A, B, and C.

Seems easy but I can't figure it out. Thanks.

First, Second, Third Grade.xlsx

Hi, welcome to the forum
Please attach the sample with with desired result

Try this out...

Here's another way (this time in alphabetical order by surname).

I should solve this with an helpcolumn to combine the first and last name.

After that with an pivot table.

See the attached file.

You can also make use of a pivot table (Without help column)

By way of correction. All of the formyuas that I used were array formulas, ...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

I've amnended the sheet, as one set of formulas didn't use your named ranges.

Blast... Change of plan. Try this. the only downside (and no doubt someone else will modify the formula or re-do it) is that you have to apply an alphabetical sort to the Table to get it into alphabetical order. But it's now picking up based on last name and first name.

see the attached file

The table will sort by Last Name and another with First Name

I was wondering if you'd rise to the challenge, nflsales. I wasn't disappointed!!