Hello Everyone,
I have a set of data which looks like:
Please Login or Register to view this content.
Where columns A and B are one data set and C and D are another. A and C are the indexes. I would like to filter the second set of data such that the indexes of both sets match. so the result would look something like:
Hope this makes sense!Please Login or Register to view this content.
Cheers!
Please attach a sample workbook so that we don't have to retype the data and can play with your data.
For how to upload a spreadsheet, check out the link in my signature below.
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
Hey QP,
This looks like and Advanced Filter problem to me. First put headers on your data in Row 1. Make the data of the Advanced Filter Columns C and D. Make the Criteria range column A and output the result to F. You could filter in place but then it hides rows. See my example:
Advanced Filter Problem Criteria on Left.xlsx
One test is worth a thousand opinions.
You can also try this macro-
It uses Column E as a rough column for the macro. Make sure column E is of no purpose. If it is then we can change it to any other column.Please Login or Register to view this content.
Check attached for an example.advanced filter.xlsm
Hi there,
Thanks for replying I attach a sample!
Cheers,
QP
Hi MarvinP,
Your solution looks great! However I am struggling to implement it! I go Data->Sort & Filter->Advanced->Select Columns C and D for "List Range" so $D:$E and then for "Criteria Range" I select column A, so $A:$A.
However nothing seems to happen! I am obviously doing something wrong, any thoughts?
Thanks!
Clear the results area first. F:G -> Clear Contents. Then instead of selecting the entire column, just select the range with data. This is most important in the criteria range of column A. Also, did you put headers on your columns? The titles of the columns for the data and criteria need to be spelled exactly the same. If you have data that grows or shrinks then using a few Named Ranges may make your work easier. See the attached where I do this for a problem with a variable dropdown list. This has vba code that does the advanced filter like you want with named ranges.
Event to AdvFilter to DNR Validation Dropdown.xlsm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks