Anyone have ADVANCED Excel skills?

[debilorrah]

I have a spreadsheet that started going wacky and I think somone changed the forumula and I can't see where it changed.......

 

[English Chick]

Nope bu if I did I would have helped you Debs...

 

[skirbo]

Have you gone through your track changes, error checking and formula auditing features?

What's it doing exactly?

Sarah

 

[greyfields]

Tools >> Protection >> Lock Cells

 

[skirbo]

Well, yeah, but that works after she fixes the problem, right?

 

[debilorrah]

Greyfiedls

It is a random trip sheet and when I hit F9 it rescrambles everything and is SUPPOSED to stay like that until I hit F9 again, however it is rescrambling everytime I make an entry - I created this thing so long ago, and I am not sure where the error is. Here is the formula...

=INDEX($H$5:$H$360,TRUNC(RAND()*((ROWS($H$5:$H$360))))+1,TRUNC(RAND()*((COLUMNS($H$5:$H$359))))+1)

 

[Fudgie]

The only thing I see right off is the columns is 359 and everything else is 360 could that do it?

 

[debilorrah]

Quote:
Nope the 359 is for the saturday entries and it only goes to row 359 for Saturdays...

 

[Fudgie]

It looks like everything matches up and all. Don't happen to have a backup on another computer do ya or in your own?

 

[skirbo]

What I see is ( after rand, in both uses of the 'word'. That also gives you no closed parens and an extra open parens.

Track changes ought to show you the last time something was changed if you had it enabled.

Also, did it just start doing this? Could you go back to a previous save/back up and just re-enter whatever data? An enormous pain, yeah.

Edited to add: The formula auditing tool has a 'trace error' function.

Sarah