linning up data in excel

April 18, 2012 at 10:49:52
Specs: Windows 7
How to line up the contents of two columns

For example the two columns are:

1 1
2 3
3 5
4
5

and I would like to be shorted as follows:

1 1
2
3 3
4
5 5


See More: linning up data in excel

Report •


#1
April 18, 2012 at 13:24:32
Assuming your data is in Columns A & B and starts in A1, put this in C1 and drag it down:

=IF(ISNA(VLOOKUP(A1,$B$1:$B$3,1,0)),"",A1)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question