Hello,
In this video we will explained the Rank formula without skipping numbers and avoid duplicate ranks.
When we use RANK formula then if two records will be same then both will get Same RANK and then next RANK number will be skipped. So in this video we will solved this problem using RANK and CountIF formula. Watch this video and get the easy solution of RANK duplicatation and repeation.
Thanks
#excel #msexcel #computer #computerscience #iti #itijobs #itiexam #cpt #msoffice