PC Review


Reply
Thread Tools Rate Thread

Advanced Filtering top values

 
 
Thomp
Guest
Posts: n/a
 
      15th Apr 2010
Basicly what I need to be able to do is to advance filter a list by
the top 25 values in column E. I have a crietra that consist of
filter by year, product and value . Year and Product are easy it is
trying to get the list to filter by the top 25 values that is hard.
What formula do I put in the critera cell that will allow me to filter
the entire list based on the top values
 
Reply With Quote
 
 
 
 
Herbert Seidenberg
Guest
Posts: n/a
 
      17th Apr 2010
Excel 2007 Advanced Filter
Macro, with top 10 filter.
Alternate solution: PivotTable:
No code, no formulas needed.
http://c0718892.cdn.cloudfiles.racks.../04_16_10.xlsm
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Advanced Filtering Opa Horst Microsoft Excel Programming 6 3rd Feb 2010 09:37 AM
Advanced Filtering Kirk P. Microsoft Excel Misc 2 19th Nov 2009 05:26 PM
how do i use advanced filtering? erik Microsoft Excel Worksheet Functions 2 18th Oct 2008 07:14 PM
Advanced Filtering Browny Microsoft Excel Misc 4 5th Sep 2008 02:30 PM
Advanced Filtering James Microsoft Excel Worksheet Functions 2 15th Jan 2004 07:51 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:24 AM.