Hello Guys,


I have two columns, where some values in column 2 would have values that are present in COLUMN 1. So I would like to list out dependent values for coulumn. Is there any way or any formula that would help me in achieving this?

I have about 2.5 K records, so manual process is bit difficult. Also to mention COLUMN 2 might have blank values too, but it would contain values present in COLUMN1.

Below is a sample of what is expected.

Validation 11 Nov.jpg


Regards,
Harsha