Get instant live expert help on I need help with excel rank if
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I cannot enter this formula into Excel. I get an error message asking for an apostrophe?IF($S2=0,"",IF($S2>0,RANK($S2,$S$2:$S$8000),RANK($S2,$S$2:$S$8000-COUNTIF($S$2:$S$8000,0)))
Solved by B. W. in 25 mins
Pivot table rank in excel 2013 is not correct
Solved by A. S. in 13 mins
How to rank in excel with multiple criteria.
Solved by S. H. in 29 mins
I need to match two column, if one number in a column number falls in a range within the 2nd column. The result is on track or off track.
Condition: (Column A: Age, ColumnB: Rank1-8)
Under Age 30, Rank 1-2 ontrack
Over Age 30, Rank 1-2 off track
Between Age 31-37, Rank 3-8 On Track
Between Age 38-45, Rank 5-8 On Track
Above 45, Rank below Rank 8 Off Track
Solved by F. Q. in 15 mins
im creating a fantasy hockey model and trying to use excel rank if formula in Excel. If someone has played more than a certain number of games, and if they're certain position how to rank them accordingly
Solved by X. D. in 23 mins