summerizing formula for weekly lesson plans

[Frank Kabel]

Hi J_J
could you please change your system time/system clock. To be honest I
simply delete these kind of posts as I don't know if this happens as an
accident or intentionally

And as Tom already mentioned this to you I suspect the latter.

 

[Frank Kabel]

Hi
no it is NOT. Still showing 10hours in advance. As david described you
have to change your time zones as well

 

[J_J]

is it OK now?

Hi
no it is NOT. Still showing 10hours in advance. As david described you
have to change your time zones as well

 

[J_J]

or now?

 

[Ken Wright]

LOL - Got there in the end JJ

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------

or now?

 

[J_J]

Done, At last...

LOL - Got there in the end JJ

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

-------------------------------------------------------------------------- --
It's easier to beg forgiveness than ask permission
-------------------------------------------------------------------------- --

 

[J_J]

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

 

[J_J]

Hi Frank,
I have cheked my system time and it seems to be OK now.
25th October 2004, 19:55
Sometimes I find that it is showing the wrong time, correct it but next time
I open it find it wrong again. Thus I am giving up hope of correcting this
error permenantly. Maybe it is due to the battery cell in the PC.
One thing for sure I never did it intentionally.
Regards
J_J