• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

To arrange Serial wise as per rate given by agency

paramveer

Member
Sir I want lowest tender rate given by firm come to First No and arrangement of Rest all the firms not a issue. Example given in excel sheet. Thanks for help to solve my problem.
 

Attachments

bosco_yip

Excel Ninja
Try,

In B20, copied across and down :

=INDEX($B$5:$Q$7,MATCH($A20,$A$5:$A$7,0),IF((A$16="Govt Rate")+(B$16="Govt Rate"),(B$18="Amount")+1,MATCH(IF(B$17>0,B$17,A$17),$B$2:$P$2,0)+(B$18="Amount")))

In C23, copied across :

=IF(C18="Amount",SUM(C20:C22),"")

Regards
Bosco
 

Attachments

paramveer

Member
Try,

In B20, copied across and down :

=INDEX($B$5:$Q$7,MATCH($A20,$A$5:$A$7,0),IF((A$16="Govt Rate")+(B$16="Govt Rate"),(B$18="Amount")+1,MATCH(IF(B$17>0,B$17,A$17),$B$2:$P$2,0)+(B$18="Amount")))

In C23, copied across :

=IF(C18="Amount",SUM(C20:C22),"")

Regards
Bosco

sir please help to find firm name like kamal, param, etc
 
Top