Equations in fil not being read correctly

  • Thread starter Thread starter Throme88
  • Start date Start date
T

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2007 file not being read correctly in 2003 2
Weighted randbetween text list 3
Insert MathType Equation 1
If cell not null use that value 1
Excel 2007 : Equation editor 0
Excel How to enable engineering functions in MS Excel 2000? 3
Equations in Word 2007 3
Equation Editor 3.0 annoying bug! Please help 0

Back
Top