Hi please help me in solving the following issue
e.g i have the follwoing date in Excel Sheet

A B C D E
1 Jon 123
2 Suso 456
3 Mary 789
4 Jon 123
3 Suso 456
5 Mary 789

IF Jon (A1) and 123(B1) are locating in (A1:A5 & C1:C5) Then Copy A1 & B1 in
D1& E1 and copy A4 & C4 in D4&E4