# Excel spreadsheet does not work for others

#### Brentsa

##### New Member
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

##### MrExcel MVP, Moderator
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.

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

#### Brentsa

##### New Member
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

##### MrExcel MVP, Moderator
Ok, which cell are you putting the formula?

#### Brentsa

##### New Member
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

##### MrExcel MVP, Moderator
Rich (BB code):
``=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.

Replies
3
Views
106
Replies
13
Views
322
Replies
3
Views
110
Replies
0
Views
116
Replies
1
Views
163