S
Sh0t2bts
Hi All,
I have a workbook that we use for keeping track of Staff.
In column A2:A50 I have their Full Names
Column B2:B50 I have their initials
Column C2:C50 Total Number of days training using this formula
"=COUNTIF(Courses,"*" & $P10 & "*") - (COUNTIF(Courses,"*" & $P10 &
"1/2" & "*")/2)"
Courses is a difined name as "=Sheet1!$B$3:$M$33"
Columns B60:M60 I have diffrent Courses
Rows A61:A92 I have dates
As this is for 100+ people it is getting difficult to count how many
people are on a training course on any given date, What I am after
doing is in another work sheet replicating the calander but in stead of
having the attendees initials visable to just show the total number
Can anyone help with this??
Many Thanks
Mark
A B C
2 Fred Jones FJ 2
3 Joe BLoggs JB 1.5
A B C
50 01/06/05 Excel Word
51 02/06/05 FJ,JB1/2 JB,FJ
I have a workbook that we use for keeping track of Staff.
In column A2:A50 I have their Full Names
Column B2:B50 I have their initials
Column C2:C50 Total Number of days training using this formula
"=COUNTIF(Courses,"*" & $P10 & "*") - (COUNTIF(Courses,"*" & $P10 &
"1/2" & "*")/2)"
Courses is a difined name as "=Sheet1!$B$3:$M$33"
Columns B60:M60 I have diffrent Courses
Rows A61:A92 I have dates
As this is for 100+ people it is getting difficult to count how many
people are on a training course on any given date, What I am after
doing is in another work sheet replicating the calander but in stead of
having the attendees initials visable to just show the total number
Can anyone help with this??
Many Thanks
Mark
A B C
2 Fred Jones FJ 2
3 Joe BLoggs JB 1.5
A B C
50 01/06/05 Excel Word
51 02/06/05 FJ,JB1/2 JB,FJ