mohamed ali abdelgawad
Board Regular
- Joined
- Nov 18, 2016
- Messages
- 71
- Office Version
- 365
- Platform
- Windows
Hi Dears
i use this formula to get unique rank
But some times i didn't get some number
like you see here . no 10 rank
so ho to avoid this issue
example sheet
Thank
i use this formula to get unique rank
Code:
=IFERROR((COUNTIF(F5:F$426,F5)-1)+RANK(F5,F$6:F$426),"")
But some times i didn't get some number
like you see here . no 10 rank
so ho to avoid this issue
example sheet
Thank