Excel spreadsheet does not work for others

[Brentsa]

Good day,

Our work make use of Office 365 Pro Plus, I've created a spreadsheet with load of formulas to assist with the verification of individual person's work for the day. The spreadsheet works 100% on my PC. But the minute any other user makes use of the spreadsheet on their PC the formulas does not work and therefore the spreadsheet does not work.

I do not understand what the issue is. Can anyone assist me?

Thanks

 

[Fluff]

If you cannot update Excel for the other users, post back & I will give you another formula, but it's going to be significantly slower than your formula.

 

[Brentsa]

If you cannot update Excel for the other users, post back & I will give you another formula, but it's going to be significantly slower than your formula.

It would help to have a different formula.

 

[Fluff]

Ok, which cell are you putting the formula?

 

[Brentsa]

Im putting this in cell A2 on a new sheet:
=FILTER('STD TellerStatisticsHistoric'!$B$1:$R$5000,'STD TellerStatisticsHistoric'!$B$1:$B$5000=Teller!A1,"")

 

[Fluff]

Ok how about

=IFERROR(INDEX('STD TellerStatisticsHistoric'!B$1:B$5000,AGGREGATE(15,6,(ROW('STD TellerStatisticsHistoric'!$B$1:$B$5000)-ROW('STD TellerStatisticsHistoric'!$B$1)+1)/('STD TellerStatisticsHistoric'!$B$1:$B$5000=Teller!$A$1),ROWS($A$2:$A2))),"")

dragged down & across.
If your putting it on the Teller sheet, remove the part in red.