Ranks in excel

[jigyansha1985]

Sir,
I have an excel sheet. In that sheet what I would like to reflect is equal rank for equal status (i.e. a/c or deno) but If A/c or Deno are zero or less then that then no rank shall be given. Main is the master sheet from which datas shall be taken for ranking. There are two types of ranking ONEDAY ( 2 fields in the main sheet are :- daydly_ac & daydly_amt for A/C & DENO) and the other one is TOTAL ( 2 fields in the main sheet are :- dly_ac & dly_amt for A/C & DENO). Ranks shall be given from highest to lower. In this way one should find easily which branch is topper. A sample is attached for your reference.
Regards
Jigyansha

[pike]

hi jigyansha1985
welcome to the forum
there are a few diffent ranks to choose from . one way ...
in

Please Login or Register  to view this content.

drag or fill down
chip has a very good Explanation here
http://www.cpearson.com/excel/Rank.aspx

[royUK]

Don't add pointless Polls to your posts

[romperstomper]

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this