Same IF function on 1 page.

[rjerand]

I have an excel document with a function that allows a list of employees to occur (in order) if an X is placed in their box on a given calendar date. Only issue is that I want to divide the group into two.

I tried for a while to modify it and came up empty. Attached is the document.

In S1 - you have AM employees (in yellow) and PM employees (in light blue) - if there is an X in their column, their name gets put in order on the list in tab S2 under the same date (I want to see the list of employees, hence why I created S2). Only issue I am having is that I want to divide them into two groups on S2. So on S2, maybe PM employees can start in like row 20?

Anywho - this seems so easy, but I am having trouble taking the function, changing a few numbers and applying it? :/

[Pepe Le Mokko]

Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your version.
Perhaps today it is "the latest", but will you change your profile when your version is not "the latest"?
Thanks

[rjerand]

makes total sense!

I have excel office 365

[JeteMc]

As you are using the 365 version lets upgrade your array entered SMALL(IF based formula to a regular (press Enter to activate), AGGREGATE based one.
For the AM names: =IFERROR(INDEX('S1'!$B$4:$B$14,AGGREGATE(15,6,(ROW($B$4:$B$14)-ROW($B$3))/('S1'!C$4:C$14="X"),ROWS(A$1:A1))),"")
For the PM names: =IFERROR(INDEX('S1'!$B$16:$B$32,AGGREGATE(15,6,(ROW($B$16:$B$32)-ROW($B$15))/('S1'!C$16:C$32="X"),ROWS(A$1:A1))),"")
Let us know if you have any questions.