Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2012
    Posts
    2

    Unanswered: Trouble with Array Formulas

    I have array formulas setup in a worksheet tracking labor and wages. One column tracks hours and the adjacent column tracks wages. In a few sets of cells, the formula copies the adjacent cell's formula. I've tried editing the formula and it changes the cell next to it. It's really crazy. Anyone know what I've done or missed to cause this or how i can fix it?

  2. #2
    Join Date
    Sep 2008
    Location
    London, UK
    Posts
    511
    Hi,
    In a few sets of cells, the formula copies the adjacent cell's formula. I've tried editing the formula and it changes the cell next to it.
    Sounds strange. Array formulas can be shared. By "shared", I mean that a single formula can be shared by several adjacent cells - is that what you mean?

  3. #3
    Join Date
    Jan 2012
    Posts
    2

    Trouble With Array - Corrupted Cells

    Thanks for the reply. I ended up deleting the rows I was having problems with and recreated the array formulas and all is fine now. It was really driving me nuts though!

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •