PROBLEM 1: How many Applicants, Male and Female in NAME table? PROBLEM 2: How to find maximum SG and Minimum SG? PROBLEM SOLVING 1: Applicant: =COUNTA(C8:C17) Male: =COUNTIF(D8:D17,"M") Female: =COUNTIF(D8:D17,"F") PROBLEM SOLVING 2: mAXIMUM: =MAX(M8:M17) MINIMUM: =SMALL(M8:M17,COUNTIF(M8:M17,0)+1)
|
