I'm not sure I follow what you're trying to do. Can you provide a bit more detail?
We have two columns, column A and column B, column A has 1 to many relationship with column B.
I want if i have the value for column A it should give me all the member of column A which has the same value in the column B.
This could be easily under stood with the SQL query if you have experience in it.
select A from table_name where B in
(select B from table_name where A = value in A);
hope you understand now
If you provide sample workbook then it would be easy to answer.
And you want to specify "Value in A" as a parameter?
Thanks for your reply.
yes I want to mention "Value in A" as a single drop-down filter, so that once user select any value for "Value in A" will return all the values which have common value for "Value in B".