hi guys, i need a formula or advise on sorting 2 different columns to match the same value in 2 columns and retaining all the other data per row. E.g. below, i want Client Code col A & F to match to same row. Those which don't match will be at the bottom rows. Please help.
e.g.
ClientCode|90D|60D|30D|Current|ClientCode|Remarks
12ddd|40|40|40|60|64|12qqq|vvvvv
12abc|60|30|39|453|12www|nnnnn
12eee|30|28|50|49|12ddd|jjjjj
12bbb|60|40|49|45|12abc|bbbbb
12ccc|50|50|60|56|12eee|ahhhhh
The result i would like to see is :
12abc|60|30|39|453|12abc|bbbbb
12ddd|40|40|40|60|64|12ddd|jjjjj
12eee|30|28|50|49|12eee|ahhhhh
12bbb|60|40|49|45|12qqq|vvvvv
12ccc|50|50|60|56|12www|nnnnn
Bookmarks