I have sheet with names in the first column and then three colums with points. I need to rank the names after column 4. In case two names have the same amount of points in column 4, then the one with the highest number of points in column 2 should have the highest rank. If they have the same amount of points in column 2 as well, then column 3 decides who is ranked highest.

It has to be automatic, so I only need to insert my data in another sheet. Then Excel will calculate the amount of points and then it should rank after these points. My sheet can calucate points but I can only get Excel to rank with one column as criteria. How can I solve this?

My sheet looks like this (made up example):

Name Column 2 Column 3 Column 4
Emil 10 15 20
Alex 5 14 30
Frank 11 10 20