How to fill duplicate sells with same values?

excel forum.PNG
Asking through small example.


As you can see in the photo column A and column E have have some duplicates.
Column B has numbers corresponding to data of column A. What I want is to paste the data of column B in front of column E but along the same values as it is for column A and B.

Example: the answer should be like :
From the data as you can see letter B in columnA has number 0 corresponding to it so print the same corresponding infront of it's duplicate letter B.
You can see letter T in columnA has number 8 corresponding to it so print the same corresponding number infront of it's duplicate letter T.

How am I supposed to this on below data?

First, welcome to the forum

Like this with column-D populated?

Hari1111996.png

If so, this is the formula in D1, copied down as far as you need:
=IFERROR(INDEX(B1:B13, MATCH(E1, A1:A13, 0)), "")

If this is not correct then please attach a workbook in accordance with the instructions in the yellow banner - especially the part about expected results!

First of all, your col-H formula is correct - sorry for my erroneous lack of absolute references in my post #2.

The problem you now have is that some of the col-E content is text and some is numeric. Col-I is all text. You can't compare text with numeric data.

The easiest way to see is to expand the width of col-E a bit then remove the center format for col-E. You will now see that E2:E15 is left aligned, meaning it is text whereas E16:E44 is right aligned meaning it is numeric.

One way to fix this is:

1. select col-E
2. Ribbon > Data > TextToColumns
3. Next , Next
4. You should now be on the screen that lets you select the format - select "Text" then "Finish"

Your formulas should now be working as expected.

No problem. Thanks for the feedback and reputation points.