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

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

"Throme88" wrote in message
...
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