# 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!”

## Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

## 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