If you want worksheet formulas, better to post this in Misc or
Worksheet.Functions

You need to set you clock back to the right time. You are several hours
ahead of everyone else.

--
Regards,
Tom Ogilvy

"J_J" wrote in message
...
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