Excel spreadsheet does not work for others

Brentsa

New Member
Joined
Oct 3, 2013
Messages
39
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Jun 12, 2014
Messages
47,960
Office Version
  1. 365
Platform
  1. Windows
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.
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Brentsa

New Member
Joined
Oct 3, 2013
Messages
39
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Jun 12, 2014
Messages
47,960
Office Version
  1. 365
Platform
  1. Windows
Ok, which cell are you putting the formula?
 

Brentsa

New Member
Joined
Oct 3, 2013
Messages
39
Office Version
  1. 365
Platform
  1. Windows
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
Joined
Jun 12, 2014
Messages
47,960
Office Version
  1. 365
Platform
  1. Windows
Ok how about
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,112,939
Messages
5,543,115
Members
410,583
Latest member
jgalin
Top