Hey all,

My question:

I have an array of data.. i then have an =IF operator working the array of data outputting "up" or "down" text in the column based on a formula.. its simple, but I just needed a way to put the relevant "up" or "down" labels down this long list of data. Also, this formula to label "up" or "down" takes into account past data, so its period dependent. The first 20 or so cells doesnt have a label until it has 20 periods to calculate.

Now, my conundrum. I'm done labeling this data. I now want to take the data out, and have a new workbook with the new data ommitting the first 20 cells so that there are no NA# cells. If i just copy and paste the data where labeling begins, in the new workbook, my array functions are pasted as well and again, labeling doesnt begin until the 21st cell.

Is tehre a way to freeze all calculations and make it "flat" so I can just copy and paste the data into a new workbook, pretending I never had to write a formula to label all the data?

Thanks in advance.


Cheers,
Amed