ReviewMyElearning.com

Excel Formula

A coworker had a pretty complex spread sheet with several sheets in it.
One sheet had monthly and yearly totals going back to 2003.
She wanted a chart on a new sheet that compared this year's data with previous years.
But only up to the current months data... so August 2009 compared to Aug. 08, Aug. 07, etc
Here is what I came up with:
=INDIRECT(ADDRESS(104,MONTH(TODAY()),4,1,"damages per 1000"))
I am far from an excel expert so I'm proud of it.
Luckily the sheet with the monthly totals is arranged so that month 1 is in col 2 etc.
So my formula above pulls row 104 from col 9 (this month) which is August on the sheet.
I had to hard code the row... :-(
Now.. would the real excel experts tell me how I could make it better?

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
  • Images can be added to this post.
  • You may use [inline:xx] tags to display uploaded files or images inline.
  • You may use <swf file="song.mp3"> to display Flash files inline
  • Twitter-style @usersnames are linked to their Twitter account pages.
  • Twitter-style #hashtags are linked to search.twitter.com.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
    _  _  _  _                  _                         _  _  _  _  _      _             _   
_(_)(_)(_)(_)_ (_) (_)(_)(_)(_)(_) (_) (_)
(_) (_) _ _ _ (_) _ _ _ _ _(_) (_) (_)
(_) (_) _(_)(_)(_)(_) _(_)(_)(_)(_) _(_) (_) _ (_)
(_) _ (_) (_) (_) (_) (_) _(_) (_) _(_)_ (_)
(_) (_) _ (_) (_) (_) (_) (_) _(_) (_) (_) (_) (_)
(_)_ _ _(_) _ (_)_ _ _ (_) (_)_ _ _ (_) _ (_) _ _ _ (_)_(_) (_)_(_)
(_)(_)(_) (_) (_)(_)(_)(_) (_)(_)(_)(_) (_)(_)(_)(_)(_) (_) (_)
(_)
(_)
Enter the code depicted in ASCII art style.