Get instant live expert help on rank excel exclude zero

“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

in Excel 2003 I would like to format cell with different color number but to exclude number zero. For example : red <8, blue >8, black 8 and 0. I type [red][<8]0;[blue][>8]0;[black]0 but in this case zero also turn red. Thank you
Solved by D. Q. in 11 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
Solved by X. U. in 21 mins
My rank formula in excel is not working =IFERROR(RANK(C4,C24:H24,0),"") please help
Solved by K. J. in 20 mins