hello,
is there anyway formula or macro for solving follow problam ? what i want just
B_col dat equally A-col like as under.
A_col B_col --- A_col B_col
1 1 1 1
2 2 2 2
3 4 3
4 6 4 4
5 5
6 6 6