Dear Frineds,
I were been trying to mark a numbering for top 3 highest and lowest value with loss and gain comment.
Coloumn B having following data
B2= -78%
B3= -75%
B4= -61%
B5= -58%
B6= 43%
B7= 44%
B8= 47%
B9= -16%
Comments are in coloumn C (want a formula)
C2= 1 Loss
C3= 2 Loss
C4= 3 Loss
C6= 3 Gain
C7= 2 Gain
C8= 1 Gain
thanks friends, missing you....
I were been trying to mark a numbering for top 3 highest and lowest value with loss and gain comment.
Coloumn B having following data
B2= -78%
B3= -75%
B4= -61%
B5= -58%
B6= 43%
B7= 44%
B8= 47%
B9= -16%
Comments are in coloumn C (want a formula)
C2= 1 Loss
C3= 2 Loss
C4= 3 Loss
C6= 3 Gain
C7= 2 Gain
C8= 1 Gain
thanks friends, missing you....