Hi,
This is a request from a primary school headteacher and a good friend of
mine.
They use an excel sheet that shows the lesson plan for each teacher. Nothing
special on it. But lately they needed some summerizing figures on the
sheets.
For each teacher, there are "names" in the region G10:K19 in its excel
sheet. The names includes a part consisting of the "lesson name" itself and
a part consisting the "class" that'l take it (For example "ScienceA1"). Thus
the "name" data can easily be seperated because the "lesson name" is at the
beginning and the "class" name always starts with a capital letter somewhere
in the middle of the text.
Now I wanna summerize this data for each teacher down somewhere on the sheet
as follow:
I want to list these lessons in the region from F24:I24 downwards such that:
F24,F25,F26,...etc will be 1, 2, 3, ...etc the number of times a unique name
is found in the region G10:K19.
G24, G25, G26, ....etc will be each found different lesson name.
H24, H25, H26, ...etc will be the involved class for that lesson (e.g A1, B2
etc).
I24, I25, I26, ...etc will be the total count of each unique lesson in the
region G10:K19.
Can you suggest formulas or a macro to do it?
Thanks in advance
J_J