9 Replies Latest reply: Mar 21, 2018 6:48 AM by Sunny Talwar RSS

    exclude selection and find top ranked sales

    Arjun Madhusudan



      I have data as below


      Company    Sales

      A                  1000

      A                     400

      B                    500

      B                      20

      C                  2000

      D                    400

      D                      20



      I need to calculate     Sum of sales selected company  divided by   Sales of company with highest sale from the remaining list ( not selected)