makingtrails
New Member
- Joined
- Nov 20, 2012
- Messages
- 14
Hi,
I'm having a slight issue with a multiple array formula I am using to copy over data from one worksheet to another.
The formula works ok but as is it a Multiply Array I have to press CTRL+SHIFT+ENTER. However my original spreadsheet has over 15,000 lines of data and as each formula differs slightly I cannot find a way to 'bulk edit' all the cells to generate the true result.
Can anyone make any suggestions on how to improve this file? maybe us another type of calculation? e.g VLOOKUP?
https://skydrive.live.com/redir?res...37&authkey=!AJ-g9qo_3NcueVY&ithint=file,.xlsx
I'm having a slight issue with a multiple array formula I am using to copy over data from one worksheet to another.
The formula works ok but as is it a Multiply Array I have to press CTRL+SHIFT+ENTER. However my original spreadsheet has over 15,000 lines of data and as each formula differs slightly I cannot find a way to 'bulk edit' all the cells to generate the true result.
Can anyone make any suggestions on how to improve this file? maybe us another type of calculation? e.g VLOOKUP?
https://skydrive.live.com/redir?res...37&authkey=!AJ-g9qo_3NcueVY&ithint=file,.xlsx
