• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Autofilter Names

vijay.vizzu

vijay.vizzu

Member
Dear All,


I have a costing sheet around 2000 rows. Now i want to display the Filtered column names in cell AQ1, like if i putting auto filter on Person name, then it will displays the criterias rows. Now i want the criteria which i have selected in autofilter it should display in AQ1.


Can it possible.


thanks

Vijay
 
I don't think so...but you could do the reverse (put criteria in AQ1, then filter) with an Advanced Filter. Would that work?

http://www.contextures.com/xladvfilter01.html
 
You must log in or register to reply here.
Back
Top