LinkBack URL
About LinkBacks
Look forward for your valuable helps on my Excel matters.
~ Malinda ~
Look forward for your valuable helps on my Excel matters.
~ Malinda ~
Hello Malinda,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hello Guys,
Need some help when Ranking in Excel.
I just want to rank my data list in Descending order while omit negative values. I used the following formula,
=IF(H23>=0,(RANK(H23,$H$22:$H$35,1)),"")
The rank received by this function also consider the negative values. How can I overcome this situation.
Please Help....
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks