# Rank two columns ?

see attached document Rank Two Columns 09-05-2016 2.ods

Rank Column B and Column E Lowest number equals = 1 , Highest number equals = 32 or highest number available given duplicate OA numbers

example:

Row 5 Column B 1 Column E 5

Row 6 Column B 10 Column E 9

I would like to Rank two columns

should read by Rank

Rank 1 Row 5 Column B

Rank 2 Row 5 Column E

Rank 3 Row 6 Column E

Rank 4 Row 6 Column B

thank you in advance for any help provided.

How do I write, =ifna(rank(???? or =iferror(rank(?????