Thread: Matching, sorting and place in appr. cell

Hi all,
This site excellent forum for excel. I just move directly to my question. i want to match and sort the same data of a row. i will explain below he my query not clear

column 1 column 2 column 3
a a a
b c b
c d c
d e e
e f f



column 1 column 2 column 3
a a a
b b
c c c
d d
e e e
f f f


but the columm a is constant, rest of column are based on column a. i think i came to perfect forum. cam any one who experienced already cam help me.
also if you want to my excel i cam upload.

Originally Posted by martindwilson

try like this you need an unique list of vales to compare against see col e

Thanks little working for me.

Can you explain the code of checking.