| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Equations in fil not being read correctly
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Equations | Excel Discussion (Misc queries) | |||
| I have a read only xl file, I need it to be read and write | Excel Discussion (Misc queries) | |||
| Trendline Equations | Excel Discussion (Misc queries) | |||
| How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) | |||
| Can't read Dutch written equations in excel files. Could before.. | Excel Worksheet Functions | |||
Threaded Mode
