Anyone have ADVANCED Excel skills?

Discussion in 'Random Ramblings' started by debilorrah, Jan 14, 2009.

  1. debilorrah

    debilorrah The Great Guru of Yap Premium Member

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

    English Chick English Mum

    Jun 27, 2008
    Cheshire UK
    Nope bu if I did I would have helped you Debs...[​IMG]
     
  3. skirbo

    skirbo Chillin' With My Peeps

    324
    0
    129
    Jul 18, 2008
    Walton County, NW FL
    Have you gone through your track changes, error checking and formula auditing features?

    What's it doing exactly?

    Sarah
     
  4. greyfields

    greyfields Overrun With Chickens

    4,889
    16
    261
    Mar 15, 2007
    Washington State
    Tools >> Protection >> Lock Cells
     
  5. skirbo

    skirbo Chillin' With My Peeps

    324
    0
    129
    Jul 18, 2008
    Walton County, NW FL
    Well, yeah, but that works after she fixes the problem, right?
     
  6. debilorrah

    debilorrah The Great Guru of Yap Premium Member

    Greyfiedls [​IMG]

    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)
     
  7. Fudgie

    Fudgie Hatching Queen - Got Fudge?

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

    debilorrah The Great Guru of Yap Premium Member

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

    Fudgie Hatching Queen - Got Fudge?

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

    skirbo Chillin' With My Peeps

    324
    0
    129
    Jul 18, 2008
    Walton County, NW FL
    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
     
    Last edited: Jan 14, 2009

BackYard Chickens is proudly sponsored by