Quote:
|
Originally Posted by Kato
Ta Joe, but there are about 450 individual items on the list in about 3000 rows. I just want a list of the individual items, not worried about the total of them.
Interestingly with a filter they are all listed in the drop down box, but I just need that in some cells instead.
|
Pivot tables work a treat for this stuff.
Select the 3000-odd rows you want, including the header columns.
Go to the task bar, Data, "PivotTable and PivotChart Report".
Hit next, next (making sure that you've got the correct data range you want to filter selected), next (just chuck it on a new worksheet), finish.
Now just click and drag the name of the column from the "PivotTable Field List" you want to get the 450 items of into the "Drop Row Fields Here" box.