My name is Lacramioara and I encounter some problems with Excel functions.
What I want is to rank a difference between two cells within the differences between values in the coresponding 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 afterwords to rank the values in column E.
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.
Could you please upload a sample EXCEL file WITH sample data, macro, formula , conditional formatting etc on some shared site like https://authentification.site , http://docs.google.com,http://wikisend.com/ , http://www.editgrid.com etc and post back here the link to allow better understanding of how it is now and how you foresee. Based on the sample book, could you re-explain your problem too