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

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

--
Message posted from http://www.ExcelForum.com