Merge unique value

[pnnaik]

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

[MickG]

Try this:-

Please Login or Register  to view this content.

Regards Mick

[pnnaik]

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

[Glenn Kennedy]

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?

[oeldere]

With an pivot table.

See the attached file.

[pnnaik]

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

[Glenn Kennedy]

Yea. Just close this thread and start another.