I have an excel sheet on which I have put Ranks for candidates according to their score.
Now I want Names as per their ranks in Column F thru any Formula (not thru sorting option)
If I use vlookup, it creates problem as there are duplicate ranks for many members.
Pls support and suggest formula to put the require data.
Rgrds
Harshit Jain
Bookmarks