LinkBack URL
About LinkBacks
Dear All,
I have data in two columns.
Column A have repetitive data.
In column B unique value.
Please help in getting a list of unique value of column A against Merge unique value
of column B.
Please find attached file.
Regards,
PN
Dear All,
I have data in two columns.
Column A have repetitive data.
In column B unique value.
Please help in getting a list of unique value of column A against Merge unique value
of column B.
Please find attached file.
Regards,
PN
Try this:-
Regards Mick
Please Login or Register to view this content.
Dear Mick ,
Thank you for your kind reply.
This is working and getting result as required. My sheet contains formula and have not used any macros. Is it possible to get result using formula or only solution is to use macros.
Regards,
PN
If you want allthe matching results to be in one cell, you will need some sort of VBA/UDF solutionj. You can use a formula if it's OK to have one result per cell, using several horizontal cells. Is that OK?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
With an pivot table.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Dear Glenn & oeldere,
Thanks for your kind reply. Actually I have dismantle my data sheet to get final solution. I think I need to use VBA code for entire data base to get result. May I present entire issue in VBA forum.
Regards,
PN
Yea. Just close this thread and start another.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks