Forum Discussion

Brownie's avatar
Brownie
Copper Contributor
Nov 13, 2022

extracttotal lines out of Subtotal Counts

I often use the subtotal feature to count how many entries there are under a single heading.  When that is done I get the answer below.  That is OK and what I want.  The problem is that the files i am working on have thousands of rows.  I need a way to quickly extract all the result lines (like 1124 count 6, 1125 count 10 etc) so I can paste the data by line elsewhere.  I've tried to filter but that takes away the total that the count calculated.  Any ideas how to do this or should I be using another method to get these totals.   Office 16

 

 

 Place# attended
 112410
 112427
 112429
 112410
 112455
 11246
1124 Count6 
 112511
 1125120
 1125125
 1125146
 112515
 1125170
 112576
 112578
 112519
 112520
1125 Count10 
 1126125
 112626
 1126120
 1126126
1126 Count4 
 112812
 112813
 112814
 112815
 112816
 112817
 112818
 112819
 112820
 112821
 112822
 112823
 112824
 112825
 112826
 112827
 112828
 112829
 112830
 112831
 112832
 112833
1128 Count22 
Grand Count42 
    • Brownie's avatar
      Brownie
      Copper Contributor
      Thank you. I have only a little experience with pivot tables but will try.

Resources