> Hi there,
>
> I need to filter rows in a sheet based on a columns matching a list of
> values.
> I've tried to play advanced filter but it doesn't seem to fit my
> needs...
>
> Any idea?
>
> Many thanks in advance anyway!!!

I sorted it out using MATCH function.

I copied my list of values in a column on a different sheet.
Then, on the original sheet where I need to filter rows I create a new
column with a formula using the MATCH function (between the value in
the column of interest at the current row and the array of values
defined in the column in a different sheet I created previously).
 The function returns the index of the matching value in the list - if
the value to match is present in the list!-  otherwise returns the N/
A.
Finally, I filter out the rows with N/A in the new function column.

If you need details just reply here.

Have a nice day.

-- 
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Reply via email to