Welcome to the Newschoolers forums! You may read the forums as a guest, however you must be a registered member to post. Register to become a member today!
Im trying to understand what's going on here - post a screen shot...
You can format the cells and choose number, set the decimel places etc etc....
you can copy and paste them as values only....
but im guessing a bit here until i understand more of what you have and are trying to achieve...
ok - it's pretty hard to help without a screen shot of the spreadsheet you have, but....
So if your "results" cells (i.e. those that are the derived values of the array, e.g. ="SUM(XX:XX)" ) are actively linked to the cells in the array, so they will always change when you alter or delete the source cells (if these are the "original" cells you refer to).
if you want to use the array function for many data sets and just keep the results, you'll need to copy the results into a separate table as values (i.e. paste special - values only), and populate that.
Another tip is to use the Dollar sign in front of values that you want to keep constant in a formula, Like D9 for example, us ("$D$9"*F7/F8/F9) etc... then no matter what you do with the equation, it will remain constant to the value in D9... (you probably didn;t follow that at all...) but it's hard to explain on here without screen shots etc.
or Record a Macro!!
I love that shit....
