Good afternoon!
I have been searching for a solution for the last couple of days. I have a excel file with 30+ headers with subsequent data to follow. The file I am working with has 6995 rows and using my COUNTIFS criteria (very extensive to paste - but my criteria works - using for other charts). I get the 475 who meet the criteria below (used PIVOT table to check my numbers - dead on). Of the 475 student that are now identified meeting the criteria, I now need to apply the QUARTILE function based on the Data from the SAT MATH, SAT READING and ACT COMP columns.
Because I have not been able to figure out how to apply the two functions together, I'm currently using PIVOT tables to filter my criteria. Once I receive the output, I double click to retrieve and have a separate spreadsheet for only those students. I then use the QUARTILE function at the end of the columns to get my numbers which I then manually enter in my charts.
Because I have to retrieve this data each term, I have begun the daunting task and have now created charts with embedded formulas to automate my processes. My processes are working perfectly except for this particular chart. HELP, HELP, HELP!!!! Or is there a different way to retrieve?
Same of data attached. I have left the QUARTILE numbers and can be viewed at the end of the report.
Is there a way to
COUNTIFS CRITERIA
1) Student is a First Time Freshman
2) Student in a Traditional track
3) Student in Term 12FALL
4) Student either in a FT or PT capacity (NA's (blanks) not included)
QUARTILE CRITERIA - The scores are based on the COUNTIFS CRITERIA
1) SAT SCORE - MATH (25, 50, 75TH)
2) SAT SCORE - READING (25, 50, 75TH)
3) ACT ACORE - COMP (25, 50, 75TH)
Bookmarks