Count number of same lines in chart

[hschultz]

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

[kaushiknsolanki · Accepted solution]

Hi,

     Have a look at the attachment.

Regards,

Kaushik Solanki

[hschultz]

That is perfect, thank you