If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > PC based Database Applications > Microsoft Excel > Trouble with Array Formulas

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 01-27-12, 22:02
zimzim zimzim is offline
Registered User
 
Join Date: Jan 2012
Posts: 2
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?
Reply With Quote
  #2 (permalink)  
Old 01-28-12, 06:14
Colin Legg Colin Legg is offline
Registered User
 
Join Date: Sep 2008
Location: London, UK
Posts: 495
Hi,
Quote:
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?
__________________
Colin

RAD Excel Blog

Other tutorials:
Array Formulas | Deleting Rows with VBA
Reply With Quote
  #3 (permalink)  
Old 01-28-12, 16:17
zimzim zimzim is offline
Registered User
 
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!
Reply With Quote
Reply

Tags
array, excel

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On