E
Ert
I have a large spread sheet and I want to know the total number of classes
for an area. Classes with the same title but at different HS need to be
counted seperately. For Example:
School Class Area
John HS Algebra Math
John HS Geometry Math
John HS Genetics Science
Jane HS Genetics Science
Jane HS Accounting Business
Jane HS Accounting Business
Total Unique Math Classes = 2
Total Unique Science Classes = 2
Total Unique Business Classes = 1
Thanks in advance.
for an area. Classes with the same title but at different HS need to be
counted seperately. For Example:
School Class Area
John HS Algebra Math
John HS Geometry Math
John HS Genetics Science
Jane HS Genetics Science
Jane HS Accounting Business
Jane HS Accounting Business
Total Unique Math Classes = 2
Total Unique Science Classes = 2
Total Unique Business Classes = 1
Thanks in advance.