=INDEX(B2:B10,MATCH(TRUE,INDEX(EXACT("SARA",A2:A10),,),FALSE))
44. Rank within the Groups
Suppose your have data like below table and you want to know rank of students.
You will simple put following formula in D
=RANK(C2,C2:C100)
But what if you are asked to produce rank of students within each school. Hence, every
school's rank will start with 1..
Put following formula in D2 for that case for Descending order ranking. (For ascending
order, replace ">" with "<" without quote marks)
=SUMPRODUCT((B$2:B$100=B2)*(C$2:C$100>C2))+
OR
=COUNTIFS(B$2:B$100,B2,C$2:C$100,">"&C2)+
45. Remove Alphabets from a String
If your string is in cell A1, use following formula to remove all alphabets from a string
