I have a rank chart and its ranking my Employees in asending order. I would like to keep all the Employees on the chart even with a 0 value, the reason why is, the Employees with 0 points are in first place. What am i missing to make this happen? Below is my rank chart, when i use vlookup to corvert this chart were is automatically updates from first to last is were im having issues, i want every employee on there at all times even when tied, but when they are tied it only shows the top guy on the list
FORMULA: =IFNA(RANK.EQ(BD3,$BD$3:$BE$16,1),"") is what im using above (Rank Chart), when i am using my actual chart im using =IFERROR(VLOOKUP(C104,AW:BE,3,0),"--") This is the displayed chart that everyone will see