First and foremost, I know that all my stats can be easily identified using PIVOT tables (used to guide me on my number for COUNTIFS formulas), but I will be pulling this report every 2 weeks AND will have to provide the same charts each time. I have already created a macro to create my report template, now I'm just creating the formulas so that when I run my macro off my report, it will generate the numbers based on my formulas.
I have spent days researching IF, SUMPRODUCT, INDEX, MATCH, COUNTIF to use with MIN, MAX, AVERAGE, MEDIAN and MODE as it relates to the following criteria, but just can't get what I need; if mentioned on the web, forums, tutorials, I've looked into it! If you refer to the "Enrollment Charts" tab from my source file, you will see what I am trying to accomplish.
Any guru's out there that can help with my dilemma would be most appreciated! Thx in advance!!! Cris
CRITERIA FOR A SPECIFIC COHORT TO DERIVE MIN, MAX, AVERAGE, MEDIAN and MODE:
Enter Term: (Col B)= "13F*" or "13U*" -- several term prefixes, but need those that start with "13F" and "13U" (original terms looks like 13Faz, 13FAJ, 13U2z, 13U2Z, etc. (13F prefix for Fall; 13U prefix for Summer terms)
Cr_Att: (H) >= 12 -- represents Full-time
Type: (J) = "TU" -- represents a Traditional student
Enroll_Stat: (K) = "FF" -- represents First-time freshman
Sx: (T) = "F" or "M"
Athlete: (X) = "" -- represents (BLANK); not an athlete
HS_GPA: (AL) > 0 AND <= 3.20 -- NEED MIN, MAX, AVERAGE, MEDIAN and MODE - based on above criteria
ACT: (AM) > 0 AND <= 27 -- NEED MIN, MAX, AVERAGE, MEDIAN and MODE - based on above criteria
SAT: (AN) > 0 AND <= 1220 -- NEED MIN, MAX, AVERAGE, MEDIAN and MODE - based on above criteria
Bookmarks