Hello...

I have an issue with being unable to figure out the best way to count a
change in data when using the Subtotal function. I have listed my data
range below:

Profile ID St P/T Name
00106100 AK 00 ALASKA PACIFIC UNIVERSITY
00106100 AK 00 ALASKA PACIFIC UNIVERSITY
00106100 AK 00 ALASKA PACIFIC UNIVERSITY
00106100 AK 00 ALASKA PACIFIC UNIVERSITY
00106200 AK 00 SHELDON JACKSON COLLEGE
00106200 AK 00 SHELDON JACKSON COLLEGE
00106200 AK 00 SHELDON JACKSON COLLEGE
00106200 AK 00 SHELDON JACKSON COLLEGE
00106500 AK 00 UNIVERSITY OF ALASKA - SOUTHEAST
00106500 AK 00 UNIVERSITY OF ALASKA - SOUTHEAST
00106500 AK 00 UNIVERSITY OF ALASKA - SOUTHEAST
00106500 AK 00 UNIVERSITY OF ALASKA - SOUTHEAST

If you notice, I technically have 3 schools, all located in Alaska.
What I have done, is used the Subtotal function so that for each change
in the Profile ID (first column), Max the State column. The problem
with this, is it return AK just fine, but this is somewhat misleading.
For my report, I actually need to "count" 3 AK's, not just the One it
returned using Subtotal.

The goal is to count how many schools are in Alaska, which should
return 3. So, there may ba a much easier way to accomplish this, and I
am open to anything. The entire list is quite large, so any help is,
as always, greatly appreciated.

** There is a reason that each school is appearing 4 times like above,
it has to do with the SQL report off the AS400, and the way the data is
output. Unfortunately, I cannot eliminate this prior to the data
output file.