Excel help with rank order?

I have a column with names and another column with numbers. I want to at the click of a on show in rank order if possible. I have tried ascending and descending and that does not work i need both columns to change together with the rows.