Looking at 3 worksheets

  • Thread starter Thread starter john
  • Start date Start date
J

john

I have 3 worksheets: 2001, 2002, and 2003

I have listed all the vendors that my company used in
those years with about 1000 in each worksheet Sorted by
total about we spend with them

For Example "company A" is always on top because we spent
the most with them all 3 years

I want to make a summary page that shows what are the top
25% of vendors that show up all 3 years

Any ideas?

P.S. on all the 3 worksheets the vendors are listed in
B6:b1000
 
I would put all the records into a single sheet with an additiona
"YEAR" column and do a pivot table.

Double clicking a grey field header and clicking the Advanced butto
gives access to an option to show the top (number)
 
Back
Top