Posted to microsoft.public.excel.worksheet.functions

external usenet poster

Posts: 8

Period of Performance calculations

I have a spreadsheet with a wide assortment of data. I have a period of
performance with start and end dates. What I want to do is to take those
dates and have a formula that will spread the necessary data across a period
of time that matches the POP.

Example:
POP Start 01/01/2008(B2) End 12/31/2014(C2)
Data: B6:B15
Years 2007 (C20); 2008 (D20); 2009 (E20); etc.

Any help would be great.

Bud1888

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculation performance	Vinod[_2_]	Excel Discussion (Misc queries)	2	November 27th 07 05:39 PM
DCOUNT Performance	Paul Dennis	Excel Discussion (Misc queries)	2	August 7th 07 06:56 AM
Performance IF(IF or IF(AND	Paul Dennis	Excel Worksheet Functions	2	July 20th 06 05:24 PM
Performance Grouping	Barry Taylor	Excel Discussion (Misc queries)	0	February 13th 06 10:04 AM
Period to Period percentage change?	cs120	Excel Discussion (Misc queries)	1	September 18th 05 12:05 PM

All times are GMT +1. The time now is 04:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us