lokeshsu
Board Regular
- Joined
- Mar 11, 2010
- Messages
- 178
Hi all,
i am using a rank formula to calculate the rank and i have multiple same values so i am using the below formula
it works for some data but not all any issue with the formula
thanks
i am using a rank formula to calculate the rank and i have multiple same values so i am using the below formula
Code:
=IF(COUNTIF($A4:K4,K4)=1,RANK(K4,$A4:$Y4,1),RANK(K4,$A4:$Y4,1)+COUNTIF($A4:K4,K4)+1)
it works for some data but not all any issue with the formula
thanks