Rank 3 columns

Hi

I have a list of competitors, and would like to create a ranked table, based on their podium finishes (1st, 2nd and 3rd)

Example
Name---1st's---2nd's---3rd's
Bob--------6--------2---------1
Fred-------4--------2--------2
Jim---------4--------1--------2
Alan-------0---------0-------1

So, the criteria would be that 1st places have precedence, then 2nd's then 3rd's

I'd welcome some advice on how best to tackle this please, and 'ideally' to exclude those with no podium finishes

Many thanks
Neil