Thanks for the additional comments, Velouria, I'll see what I can do with those.
Hi Riny and Velouria, thanks for your replies. I didn't realise you can hide columns in pivot-tables, that's a good enough solution for my needs. ...
Thanks Riny. I should have had a play with the pivot-table options myself re. columns. As always, looks simple once you know how. I tried the GETPI...
Thanks Velouria. I'll take a look at the GETPIVOTDATA formula, learn how to use that function. But just for possible future benefit, is there a sol...
I ran additional COUNTIFS calculations for each of the 361 offence types, to calculate the sub-totals for 'Plea Guilty' (column L in the Example 1 scr...
Okay, so I've implemented both methods. Velouria's formula =IF(G2=G1,J1,COUNTIF(G:G,G2)) took about 20 seconds to calculate (it actually took longe...
So many great ideas, pleased I found this forum and asked the question. Thanks to all of you.
Hi Riny. I wondered if it was possible to use VLOOKUP on a pivot table, after Velouria suggested the GETPIVOTDATA function - that sounds like an ideal...
Thanks, Hans. So you you copied my COUNTIF formula in column J down to all rows, then ran the calculation for all of the 810k rows which took just ...
My bad, turns out GETPIVOTDATA is available in my 2010 version of Excel. I'll take a closer look at that, could be very useful, thanks Velouria.
Hi Philip - as you can probably tell, I'm somewhat new to all this. But I think I've managed to upload the large s/sheet to Google Drive, here's the l...
Hi Hans, thanks for looking at this. Since my initial posting of this issue, I've discovered that the s/sheet I've been working on is not confident...
Hi Mynda, thanks for replying. Yes I created a pivot-table as you suggested, and noticed it creates the sub-total counts for each of the 362 catego...