5 Replies Latest reply on Sep 28, 2016 5:02 AM by Shinichiro Murakami

    Making Custom Bins

    Aleksandar Aritonovski

      Hi all,

       

      I have 40 Companies, and want to group them into custom bins, regarding their sales. Example: number of companies with sales from $250-$500, com. from $500-$1000 etc.

      There are 5 companies that have Two Sales: Com A ($2,000 & $25,000), Com B ($1,200 & $85), Com C ($4,500 & $14,400) etc.

       

      How to make Custom Bins, and count the number of companies that are within the bin's range, but not double count those that have two sales values?

       

       

      I've included the workbook for your reference.

       

       

      Thanks much!

      Alex