Max,
I have uploaded a new file for you to have a look at, it might make it a bit
clearer and all the columns are in the correct place. I will try to explane
it a bit clearer. Where column C is different to column B and there is a date
in column D these and only these records I am interested in. In the summary
table B19:G28 I have created a row for each temporary grade. I now need to do
a couple of calculations using the date in column D and comparing it with the
current date shown in column I. The figure in column J is the difference
divided by 30 to give the average month. There does not appear to be any
correlation between the formula and the grades that are being looked at. When
I change the date in column D to make the time period shorter the figures in
the summary table do not alter to reflect this.
http://freefilehosting.net/download/445fj
"Max" wrote:
But I didn't presume the biz areas in the source Sheet1 were unique. They
could be multiple occurences, with different corresponding dates.
For easy ref, here's my test file based on my 1st response:
http://freefilehosting.net/download/44393
sumproduct bucketing by age.xls
Still think that my earlier interp & bucketing suggestion (with the
underlying assumption of 1 month = 30 days) was not incorrect. If your actual
scenario is different, upload your sample (you can use the same free filehost
link) then throw the link to it in reply here.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,500 Files:370 Subscribers:66
xdemechanik
---
"Chris waller" wrote:
FAO: Max, thanks for your response, but unfortunately it does not work the
way I expected. A2 down which you refer to as unique business areas are not
exactly that. There can be multiple occurrences of the business areas within
the list. What I am trying to do is count those areas, but to put them into
some kind of timeframe, hence the summary table. For example, if there are
two business areas and they have a date in each which is about a month apart,
these need to be counted but as the first goes over the six month period that
should be recorded under the 6-12 months column whilst the other should be
shown under the 0-6 months column. I hope this makes it clearer?