Staff Rota Formula

[runderwood10]

Hey everyone.

I've created a staff rota spreadsheet which takes a list of staff members and returns 2 staff names with either a blank "date" cell or the oldest date.

I'm a bit stuck though as I can't seem to get the formula to return 2 unique names. Here are some images to explain further, you will see for Centre 3 on the Formula tab that it is returning the same staff name twice - is anyone able to help at all?

The formula is as follows:
=INDEX(IFERROR(FILTER('Staff List'!$B$2:$B$80,('Staff List'!$C$2:$C$80=C$1)*('Staff List'!$D$2:$D$80="")),FILTER(SORT(FILTER('Staff List'!$B$2:$D$80,('Staff List'!$C$2:$C$80=C$1)),3,1),{1,0,0})),SEQUENCE(2),SEQUENCE(,1))

Thank you so much in advance!

 

[runderwood10]

Thanks for that.
The formula in A2 is looking at C1 for the centre not A1

So sorry, I should have spotted that!

Thank you so much for your help, hugely appreciated.

R

 

[Fluff]

Glad to help & thanks for the feedback.