Equations in fil not being read correctly

[Throme88]

Ok, so below is the equation I have with my cells I am having trouble with:

=INDEX('Front End-MSP'!A1:A22,RANDBETWEEN(1,COUNTA('Front
End-MSP'!A1:A22)),RANDBETWEEN(1,1))

I have excel 2007 at home on my PC, at my office we only have 2003 version.
The equation above work perfectly at home, but when I attempt to open it at
the office it comes up with a "name" error. Does anyone happen to have any
ideas for me?

Thank you

 

[Rick Rothstein \(MVP - VB\)]

You should really only post your questions once and then wait (not every
volunteer is online all the time to answer posted questions; sometime they
sleep, go out of the house, etc., so you should be patient and let at least
half a day go by before re-posting a question). By the way, I just answered
this question for you in your other posting.

Rick