INDEX/MATCH Formula?

[F J]

Hi, I need help with a formula. My data looks like this:

Column A Column B
1 3
2 7
3 5
4 8
5 1
6
7
8
9
10

And I need it to end up like this:

Column A Column B
1 1
2
3 3
4
5 5
6
7 7
8 8
9
10

So, in other words, the numbers in Column B need to end up in the same
row as their corresponding numbers in Column A. To do it manually
will take forever as the real data is thousands of rows long. Can
this be done with an INDEX/MATCH formula of some kind? I’ve tried a
few different things on my own but I clearly don’t know what I’m
doing. Any help would be greatly appreciated.

 

[Ms-Exl-Learner]

Can you please explain why you have skipped the 2,4,6,9 & 10 values in
B Column? Any reason behind this? In which method these numbers are
skipped?

 

[F J]

Hi, the examples I gave just use random numbers. No numbers are being
skipped. They just don't exist in Column B. In reality, the data
looks more like this:

Column A Column B
3000 7500
5000 6000
1000 5500
8000 3000
2000 2500
2500
5500
7500
7000
6000

And I want it to look like this:
Column A Column B
3000 3000
5000
1000
8000
2000 2500
2500
5500 5500
7500 7500
7000
6000 6000

I just want to get it so that the numbers in Column B are in the same
row as that same number in Column A. There are more numbers in Column
A than there are in Column B and not every number will have a match.
Unfortunately, there are thousands of rows, so it would be difficult
to do this manually.

 

[Claus Busch]

Hi F J,

Am Fri, 9 Jul 2010 02:15:29 -0700 (PDT) schrieb F J:

I just want to get it so that the numbers in Column B are in the same
row as that same number in Column A. There are more numbers in Column
A than there are in Column B and not every number will have a match.
Unfortunately, there are thousands of rows, so it would be difficult
to do this manually.

in C1:
=IF(COUNTIF(B:B,A1)>=1,A1,"") and fill down.
Select Column C and copy. Select B1 => Edit => Paste Special => Paste
Values


Regards
Claus Busch

 

[F J]

Hi, Claus, thank you so much! I just tried your formula and it
worked great! I really appreciate your help!

 

[Ms-Exl-Learner]

I am using google reader for viewing the post and the post are
reflecting very late in google reader and anyway you got answer for
your query.