P
PayPaul
I have a spreadsheet that indicates the number of users for various products
from over 255 companies in rows. When I tried to create a pivot table and a
chart using those companies as row data I got a jumbled mess. I'd like to
filter the existing worksheet by the criteria of a certain number of users
per company and above that number.This would reduce the number of rows. Is
there no other way than using Advanced filter and having to alter my
spreadsheet or create a new one to include extra areas for criteria range
formulas. I want to include as many companies as possible without deleting
them arbitrarily from the rows field in the pivot table. I'm using Excel 2003.
Thank you in advance,
Paul
from over 255 companies in rows. When I tried to create a pivot table and a
chart using those companies as row data I got a jumbled mess. I'd like to
filter the existing worksheet by the criteria of a certain number of users
per company and above that number.This would reduce the number of rows. Is
there no other way than using Advanced filter and having to alter my
spreadsheet or create a new one to include extra areas for criteria range
formulas. I want to include as many companies as possible without deleting
them arbitrarily from the rows field in the pivot table. I'm using Excel 2003.
Thank you in advance,
Paul