SortBy & Filter Formula Trouble

Hello, I have a roster I would like to have automatically filter out and organize by Anniversary Date in ascending order. I have the roster in a table format. Was not planning on having the filtered list display in a table format.

I've figured out the Filtering part, but when I try to add the Sortby to the formula, I get the dreaded #Value or Spill errors.

My Filter formula I have working fine, it varies in a few places based on criteria, but you get the gist:
=FILTER(Table28[Combined Name],(Table28[Code]=B3)*(Table28[ID]=C2),"")

The operating formula when I try to add the sort by is:
=SORTBY(FILTER(Table28[Combined Name],(Table28[Code]=F3)*(Table28[ID]=G2),""),Table28[Anniversary Date],1)

I understand that I can reorganize my Roster by Anniversary Date and get the result I want, but I also want a stable filtered list, as I will reorganize my roster depending on needs.


Also, does anyone recommend an online course focusing on formulas, complex like the above?

Another option

Formula:

Please Login or Register  to view this content.

A more robust version of my formula in-case columns are added or removed

Formula:

Please Login or Register  to view this content.

The Let function is new to me. I guess I see why it works, but I'm curious why it is necessary. Please don't misconstrue, I appreciate both of your solutions and I will be implementing, thank you! Is there something about a Sort/Sortby function specifically not typically cooperating with a Filter function at the same time? Perhaps something related to typically they would both return a list and that competing display is what is causing my original error?:

I'm curious why it is necessary

It isn't necessary, it just saves doing the same calculation multiple times.

The sortby range must be the same size as the data you are sorting, with your formula you filter out some rows, but the sortby range is the entire table, so they are different sizes.

Thank you both again! After googling I had thought it was something about the same size being necessary, but I discounted that as I thought since my columns were the same size it shouldn't be an issue.

Glad to help & thanks for the feedback.