2 Replies Latest reply: Apr 25, 2016 10:14 PM by Raja Mohan RSS

    How to create unequal range to found count of tickets?

    Raja Mohan

      Dear All,

       

      I have a requirement to create an unequal range to found the count of tickets as follows:

       

      In the attached excel, ticket sheets has the ticket no for the respective data.  The no. of tickets should be shown in the range of the data as shown in the range sheet.

       

      Please help how to achieve this?  I tried with the interval match function which is not working.

         

      Min_NetGrowthHeightPercentageMax_GrossGwtHtPercentageRange
      0.0129.990.01-29.99
      3054.9930.00-54.99
      5559.9955.00-59.99
      6064.9960.00-64.99
      6574.9965.00-74.99
      7599.9975.00-99.99
      100125100.00-125

       

      For each range, I wish to find the count of tickets. 

       

      Pls. help.

       

      Thanks.

       

      Best Regards,

      Raj.