Prev: Compare Sheets and highlight differnce
Next: How do I set up more than 3 conditional formatting?
From: Khimasia on 19 May 2010 05:11
Ive got a string of weekly data ranging from 1993-2010, which i need to
convert from weekly to monthly.

Id like to do this so that in the future new weekly data can be
automatically converted to its monthly average.

Whats the best way to do this?
From: Pritesh on 19 May 2010 07:32
Maybe this will be useful to you...

Step1: (If your weekly-date is in column B) Make a new column near your
data, with formula in each line as "=eomonth(b1,0)"
This will bring month value of each data-line, so later you can
summarise/condense your data through this column value.

Step2: In your monthly summary, use reference to this newly made column
instead of weekly-date column.

--
Regards,
Pritesh


"Khimasia" wrote:

> Ive got a string of weekly data ranging from 1993-2010, which i need to
> convert from weekly to monthly.
>
> Id like to do this so that in the future new weekly data can be
> automatically converted to its monthly average.
>
> Whats the best way to do this?
 | 
Pages: 1
Prev: Compare Sheets and highlight differnce
Next: How do I set up more than 3 conditional formatting?