I need a formula that will rank on two columns. So with the below example I
want to rank by Column 1 first, then by 2. So the answer would be as follows
in the below table. If there is a way to make it ascending and descending
rank, that would be helpful to know as well.

Column 1 Column 2 Formula answer
a 1 1
b 2 1
a 3 2
b 4 2

Thanks in advance