J
jerrymoon1
I have data that I would like to rank and sort by variance of forecast
minus actual
K2-N2 are locations Dallas, Houston, Baton Rouge, New Orleans.
K3-N3 is actual data values of 56.50, 49.60, 47.50 and 51.80
K4-N4 is budget data values of 47.70, 33.70, 31.30 and 42.58
K5-N5 is formula of row 4 minus row 3 (example =k4-k3)
K6-N6 need to have rank of values in row 5, going from 1 thru 4
I would like the data ranked and then displayed in the same rows in
Columns C-F
I want to use formulas to do this because this will be updated
monthly, and i am not very knowledgeable in Macros. Will provide a
example if it will help.
Thanks.
minus actual
K2-N2 are locations Dallas, Houston, Baton Rouge, New Orleans.
K3-N3 is actual data values of 56.50, 49.60, 47.50 and 51.80
K4-N4 is budget data values of 47.70, 33.70, 31.30 and 42.58
K5-N5 is formula of row 4 minus row 3 (example =k4-k3)
K6-N6 need to have rank of values in row 5, going from 1 thru 4
I would like the data ranked and then displayed in the same rows in
Columns C-F
I want to use formulas to do this because this will be updated
monthly, and i am not very knowledgeable in Macros. Will provide a
example if it will help.
Thanks.