How to sort?

  • Thread starter Thread starter laserbrain
  • Start date Start date
L

laserbrain

Hi @all,

first of all you have to know that i'm a excel newbie.

My Problem is a sheet with to columns of different lenght. Bot of them
numeric. Maybe all but nearly all of teh numbers in the shorter column
are also in the other pne. Now i want to move each number in the
smaller column to the same number at the other column.

Something like:

123 | 123
| 124
234 | 234
| 345
| 456
567 | 567

Is this possible? Could you please give me a hint?
 
Hi Laserbrain
Assuming row 1 & columns A & B contain your data.
Use column C as a helper column enter formula in C1
=VLOOKUP(A1,$B$1:$B$7,1,FALSE) run down to last row of
Column A.
Right click Column C -- Copy
Right click Column C -- Pastspecial -- Values -- OK
Press Ctrl + H
In Find What: enter #N/A and leave Replace with: blank
click on Replace All button -- Close
Right click Column C -- Copy
Right click Column B -- Paste
Right click Column C -- Delete to rmove helper column


HTH
Bob C.
 
Back
Top