Posts by Nim_rod007

Re: Calculating Volatility

Thanks for your help guys!

Hi,

I need to calculate the volatility of a series. I know that the easiest thing to do is to select the range and run data analysis. But, I just wanted to get everyone's thoughts as to which is the best measure and how it can be used in Excel. Thanks!

J

Re: Editing multiple formulas in a sheet

Pangolin/DR,

I got it. I had to put the single quotes around 'NY-NJ'. Also, instead of selecting the whole sheet and doing a relplace all, I selected a single cell and did a replace all. This seemed to help.

Regards,

J

Re: Editing multiple formulas in a sheet

I created a formula:=CT!H26/CT!$BA26 on one of my sheets. I copied this sheet on the same spreadsheet. I need to replace the reference to CT! worksheet in the above formula with NY-NJ! worksheet. Everything else remains the same.

When I do a find and replace, a window with 'File not found' message crops up.

Thanks!

Jerry

Re: Editing multiple formulas in a sheet

Hi Pangolin,

I tried doing edit and replace. It tries to look for a file and then hangs. Any idea what's going on? Thanks!

J

Hi,

I have a sheet in which every cell is a formula. The problem is that the formula references a wrong sheet. Is there a way to edit the formula without going into each cell.

Thanks!

J

Hi,

I have a list of my friends in Excel. I want to send holiday greetings to all of them individually using Outlook Express. Is there a way to do it? Thanks!