Align two columns of data

ravngm

New Member
Joined
Apr 2, 2004
Messages
1
I have two columns of data of different lengths (more rows in one column). I need to compare the second column to the first and align (by row) similar cells. How can you do this???
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

jscholds

New Member
Joined
Mar 28, 2004
Messages
7
Hi There,

Welcome to the board..

Copy this into your third column..

=IF(ISNA(MATCH(B1,$A$1:$A$15,0)),"",B1)

Paste the shorter list into the first column and then the longer list in the second column.

You might want to extend the range also ",$A$1:$A$[to last cell of second column],0"..

Hope this works..

Have a good weekend..

Jakob
 

Watch MrExcel Video

Forum statistics

Threads
1,095,806
Messages
5,446,572
Members
405,409
Latest member
croc23

This Week's Hot Topics

Top