pivot table+put unique data in 'row area'+count of items in 'data area'

B

bubz

hi. i have 2 questions:
1. i have a blk of data where I want to group by text. What I'm doin
now is to count the data and manually copy and paste.
eg:
DECREASE IN PROCESS, DECREASE NI PREPARATION
DECREASE NI PREPARATION,, INCREASE IN COST
INCREASE IN TIME, INCREASE IN TIME

will show:
DECREASE , INCREASE
PROCESS 1 0
PREPARATION 2 0
TIME 0 2
COST 0 1

2. i need to get variables from the data area and list all on the row
area, so that the data area shows the count. (not all columns have th
same data)
eg.
1st,2nd
A,B
C,B
A,B

will sort to:
1st,2nd
A 2,0
B 0,0
C 1 ,3

thanks. charlen
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Deleting decreasing data and naming rows. 5
modified pivot table using a macro 2
I'm trying to do a "count" function at the end of a dynamic pivot table 0
Selecting Date Range in a Pivot using VBA 0
Filter and excluding line item from filter 0
Comparing multiple rows of data 7
counting blocks of data 4
Need macro code to pick data according to year selected 1

Top