Same texts swapped in 2 Columns need to be plot once

[Sekars]

Hello Friends

The Inputs are in Cells C5:D28 (Column C and D) and need to remove the duplicates in the light yellow cells F5:G14 by formula.

The duplicates are repeated in the rows but changed their position i.e., columns

thanks in advance.

[Glenn Kennedy]

please don't delete posts and get moderators to close them... and then open a new thread with EXACTLY the same request. It's messy. Just "bump" your original back to the to of the queue.

It took me a while to get this one clear in my head, but:

=IFERROR(INDEX(C:C,AGGREGATE(15,6,ROW($C$5:$C$13)/((COUNTIFS($I$4:$I4,$C$5:$C$13,$J$4:$J4,$D$5:$D$13)=0)*(COUNTIFS($I$4:$I4,$D$5:$D$13,$J$4:$J4,$C$5:$C$13)=0)),1)),"")

copied across and down.

[boopathiraja]

Hi Sekar,

Try this

F5 =

Please Login or Register  to view this content.

G5=

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.

[Sekars]

Thanks to both of you, I will use the Non Array formula from Glenn.

Your formulas will help me to save time.

Thanks again.