I know my way around Excel pretty well, though not an expert.

I have created my an Excel file with information for each player in a
sports league whose playing rights is held by one of our teams. Essentially,
the file serves as a crude player database with the following column
headings saved as named arrays:

Master (this is a unique ID number)

Last_N

First_N

Team_ID (number assigned to a specific team)

Team (text name for team)

Status (designates player status by number denoting 1 for active,
2-inactive, 3-suspended...)

Jersey (uniform number)

Pos.

Ht.

Wt.

Birthdate

Age

Hometown

College

Each row has also been saved as a named array starting with P_1 through
P_329, noting that there are 329 players in the League.

Is there a method (without using Pivot Tables) to produce a roster of active
players for each team in a separate list?

If team=x and status=1 then display Jersey, Last_N, First_N, Pos., Ht., Wt.,
Birthdate, Age, Hometown, College for Team X

If team=y and status=1, then display Jersey, Last_N, First_N, Pos., Ht.,
Wt., Birthdate, Age, Hometown, College for Team Y