How to rank a number within the differences between two columns cells

[Lacra]

Hello,

I’ve encountered some problems with Excel functions.

What I want is to rank a difference between two cells within the differences between values in the corresponding columns.


More specifically, in column D, I want to rank B3-C3 within all differences between values in columns B and C, without calculating first the differences in column D and only after to rank the values in column E.


B C
Man Woman
1 2,34 3,65
3 3,40 4,76
3 4,00 3,54
4 4,50 3,45
5 3,90 2,68
5 2,10 4,31

Sorry if you find this question very simple, but I just don't know how to do it.

Please answer if there is any solution.

 

[Peter_SSs]

Welcome to the MrExcel board!

Why not just calculate the differences in another column, hide that column if you don't want to see it, and use that differences column to do your RANK?