C
Charlie Brown
Hi
I have a long list of names (col D) and a date (col G) when they attended a
course. Every person needs to attend a refresher course within 12 months. I
am trying to predetermine who will be on the course in 12 months time, plus
or minus a week or two, the problem is the course may have 12 persons
attending or 6 depending on the number of trainers. Several courses are
available on a rolling basis. I guess this is a queuing problem.
So far I have worked out the lapse time in days (col J), and the rank (Col
K) then I used:
=OFFSET(D$11,MATCH(SMALL(K$11:K$38,ROW()-ROW(M$11)+1),K$11:K$38,0)-1,0)
(col M) to put them in order of priority to be trained (the names will be
unsorted so I am not sure if Vlookup will work). I now want to make my
tables of names using control boxes to give me a list of 12 or 6 names.
I am not sure if this is possible to do with formulaes, do I need VBA?
Charlie Brown
I have a long list of names (col D) and a date (col G) when they attended a
course. Every person needs to attend a refresher course within 12 months. I
am trying to predetermine who will be on the course in 12 months time, plus
or minus a week or two, the problem is the course may have 12 persons
attending or 6 depending on the number of trainers. Several courses are
available on a rolling basis. I guess this is a queuing problem.
So far I have worked out the lapse time in days (col J), and the rank (Col
K) then I used:
=OFFSET(D$11,MATCH(SMALL(K$11:K$38,ROW()-ROW(M$11)+1),K$11:K$38,0)-1,0)
(col M) to put them in order of priority to be trained (the names will be
unsorted so I am not sure if Vlookup will work). I now want to make my
tables of names using control boxes to give me a list of 12 or 6 names.
I am not sure if this is possible to do with formulaes, do I need VBA?
Charlie Brown