Date Tracking

flexinau

Board Regular
Joined
Sep 22, 2002
Messages
122
Hi Excel Buddies,

You are all experts!!!!!

How is it possible to track the dates for when data are changed?

For example:
Column A is a type of yoyo
Column B is the rebate % for the yoyo

For Yoyos, the rebate rate might be 10% on 9 Oct 02. The rebate rate is amended to 12% on 15 Nov 02. This means that the effective date of the rebate of 10% on the yoyo is from 9 Oct 02 up to 14 Nov 02. Any yoyo bought from 15 Nov onwards will attract a rebate of 12%.

Now if you need to have a database showing a particular type of yoyo with the rebate rates for a period of 1 year, you will need to show the different rebate % and the period the rate relates to.

Sounds simple but not really.....

I guess the format in this case does not really matter much as long as the result shows the different rebate percentages and what dates they are effective.

Note that the only data available is the continual update of rebate rate for the yoyo on the same sheet as the percentage changes.

Thanks in advance
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
Thanks Mark, you are a champ!!!!!!!!!

Are there any limitations on this functionality other than the number of row limit??
 
Upvote 0
Thanks, the history changes should be accurate. The only issue is the archiving of it.

Have a great day....
 
Upvote 0
Mark,

Is this tracking able to be applied to track changes to results to the formulas even though the formula itself has not changed?
 
Upvote 0
On 2002-10-08 21:45, flexinau wrote:
Mark,

Is this tracking able to be applied to track changes to results to the formulas even though the formula itself has not changed?

It tracks changes to cell contents as a result of an edit. A cell containing a formula such as =NOW() would not be listed once the worksheet was recalculated; however, if B1 contained =A1/10 and A1 was edited then A1 would be listed.
 
Upvote 0
You could assign the rebate via a Lookup
and the the Lookup table would log the changes.

=VLOOKUP(B2,dRebates,2)

dRebates Date effective Rebate %
 
Upvote 0

Forum statistics

Threads
1,211,880
Messages
6,104,547
Members
447,915
Latest member
jpearson

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top