11 Replies Latest reply: Apr 3, 2013 4:04 AM by Hein Schultz RSS

    Count number of same lines in chart

    Hein Schultz

      Hi guys.

       

      I hope someone can help me please. I actually think this should be quite easy, but i cannot find anything on it.

       

      I have a chart (that will eventually become a pivot table) that has the calculations i require. However, i need to devide my value with the total instances of the same on the chart.

       

      So in this example, i need Plan z1 to show 2, and the rest 1. I can then use this number to devide as needed.

       

      If anyone can please guide me in the right direction. Thanx