Out needed based on Alphabetical sequence

[pramoth.u]

Hello All,

Good Noon,Please help to getting the output based on alphabetical sequence.

Sample data is attached for your ready reference.

Thanks in advance

[Olly]

In F3:

Please Login or Register  to view this content.

In G3:

Please Login or Register  to view this content.

Copy down.

[samba_ravi]

f3=IF(C3>D3,D3,C3)
g3=IF(C3<D3,D3,C3)
Try this and copy towards down

[samba_ravi]

if you have multiple columns then try below formula in f3 try below formula and copy across
=IFERROR(INDEX($C3:$D3,MATCH(COLUMNS($F3:F3),INDEX(COUNTIF($C3:$D3,"<"&$C3:$D3)+1,0),0)),E3)

[pramoth.u]

Thanks Olly,it providing the exact output of what am looking for

Please guide me logic of this formula so that i can try it in near future.

[pramoth.u]

Thanks Siva,I was struggling to find the logic to get the output.you also made it simple it can be done using IF condition.