Some corrections again for a couple of my example formulas.

I left a couple of semicolons (my Windows is set to use semicolons as
delimiters) not replaced with commas in one formula. The right formula is
below. NB! Semicolons in array parameter (the one wrapped within {}) must
remain ast they are!
=IF($B2="","",MATCH($D2,{"Courses taken";"Courses needed";"Courses placed on
hold"},0)+COUNTIF($D$2:$D2,$D2)/100)

And in another formula I simply typed the function into wrong position. The
right formula is
=IF($D2=Report!$B$1,COUNTIF($D$2:$D2,$D2),"")

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Kessie" wrote in message
...
Hello Arvil,

Thank you so much for your help. I really appreciate it. I'm glad there
are
experts like you on Microsoft website to help dummies like me (laugh).

I will try the examples you gave me. If I get stuck, I'm going to study
SQL
and Excel programming more, since I really don't know them that well.

Thank you again!

Kessie:)


"Arvi Laanemets" wrote:

Hi

Sorry, I forget something in SQL string example
SELECT CourseTable.CourseName, CourseTable.Course.Time, ... FROM ´C:\My
Documents\CourseWorkbook´.CourseTable CourseTable WHERE
CourseTable.CourseName < '' AND CourseTable.CourseGroup='Courses taken'
ORDER BY CourseTable.CourseTime, CourseTable.CourseName;

And there was an abundant semicolon in array parametrer of formula
containing MATCH


--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets