Hi You can use the formula =RANK(C5,$C$5:$C$14)
I have used Rent as the Ranking Criteria. If you want to use Total Collection, simply change C5 in the above formula to E5.
Copy the formula in all the required cells. Thanks Ashish On 5/13/2011 8:20 PM, Rajesh K R wrote:
Hi Experts, Pls find the attachment and tell me how to rank the rooms as per the collection received from them. Regards Rajesh Kainikkara
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
