PROBLEM 1: How to seperate the last name? PROBLEM 2: Rank some criteria in Excel PROBLEM SOLVING 1: =TRIM( RIGHT( SUBSTITUTE(A5," ", REPT( " ", LEN(A5) ) ), LEN(A5) ) ) PROBLEM SOLVING 2: =RANK(E6,$E$3:$E$14,0)
