Rows populating twice instead of only once

[ilovejellybeans]

I have rows that are populating twice for some reason and I would like some help to resolve this issue. Each row should be appearing once to show that an employee is working in that particular area. An example of where I am seeing this issue is first on the day sign in on October 24th and nights sign in on October 18th. To make changes to the schedule, type in any date from October 11th to October 24th in cell A2. I believe it is a small formula error since the evening sign in tab is working fine. Thanks for the help!

[FDibbins]

You are getting repeat names because you have repeat areas in col B.

[Glenn Kennedy]

I have just looked at day sign in, which I assumed (you did not tell us) was shift 1. There are a number of positions (column A) which were blank in shift 1, so I put in some randomly selected numbers (green shading) for testing.

Use this formula in Day SI, A5, copied across and down:
=IFERROR(INDEX(MAIN!A:A,MOD(AGGREGATE(15,6,(COLUMN(MAIN!$E$2:$R$2)*1000000)+ROW(MAIN!$E$3:$R$48)/((LEN(MAIN!$E$3:$R$48)>1)*(MAIN!$E$2:$R$2='Day Sign in'!$A$2)),ROWS($1:1)),1000)),"")