Hello - synopsis - worksheet with 5225 rows and 13 columns - contains dept
numbers and detailed monthly expenses for each dept. I only need info for 20
depts which equals about 500 rows. I've been sorting by Dept number then
deleting the depts I do not need ; then creating a pivot table .
Problem .
Since my dept nos are not in numberical order so I still have to go thru
the list to delete the ones I do use. Is there a way to extract the
department nos I do use instead or deleting the ones I do not use or another
faster way to do complete this task. Thanks

I'd add another column to the raw data.

Put in a formula that evaluates to something nice:

=if(or(a2={"dept1","dept2","dept20"}),"keep it","hide it")

Then I could make this field a page field and show/hide what I wanted.

In fact, I'd put that list in another worksheet and use a formula like:
=if(isnumber(match(a2,sheet2!a:a,0)),"keep it", "hide it")

It might make adding/deleting the departments easier.

Wanna Learn wrote:

Hello - synopsis - worksheet with 5225 rows and 13 columns - contains dept
numbers and detailed monthly expenses for each dept. I only need info for 20
depts which equals about 500 rows. I've been sorting by Dept number then
deleting the depts I do not need ; then creating a pivot table .
Problem .
Since my dept nos are not in numberical order so I still have to go thru
the list to delete the ones I do use. Is there a way to extract the
department nos I do use instead or deleting the ones I do not use or another
faster way to do complete this task. Thanks

--

Dave Peterson