Need the RANK function to include 0
=RANK(B2,$B$2:$B$11,1) doesn’t pick up 0%
Tried an IF
=IF(B2>=0,RANK(B2,$B$2:$B$11,1),””)
These are cells with a formula calculating a % result - really basic stuff. Works with all cells greater than Zero. Can’t understand why the RANK function seems to default to ignore ZERO - also tried RANK.EQ. Any solutions appreciated.
Are you sure the cell (or formula) contains zero and not ""?
What is your formula?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
It contains “0” returned from an IFERROR
Got it - just needed that little prod on my brain. Cheers.
Good stuff
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks