Lookup question...

B

Bud1960

Hi!

I have 3 columns; colA = Instructor name, colB = term, and colC =
activity code. colC has either an A or a D in it. What I would like to
do is return the number of A's in colC, but only those that pertain to
each unique record in both colA and colB.

Is there any way of doing this by selecting the three columns?

Thanks!
 
B

Bud1960

Ok, I'll try this again...

I have 3 columns with data in.

Column 1 has the Term associated with the data in the next 2 cells nex
to it.

Column 2 has a code, (N)ew, (R)eturning, or (F)ormer student.

Column 3 has 1 of 2 codes that show if the student has (D)ropped o
(A)dded a course.

I would like to know if there is a way by selecting all the data in th
3 Columns that I can return a table of information that reflects th
number of New students that Dropped a course in a specific Term.

If that is not clear, I will try again, but I cannot post the fil
because it contains sensitive data.


Thanks
 
Top