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
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(???