Align data in different columns

**Lozhaze** · 07-19-2012, 07:05 AM

Hi there, I'm a bit stumped here

I have 2 columns of different lengths in both of which some cells contain the same names.

i need to align the names in column B to those that match in column A

Sample attached.

align data sample.xls

Many thanks.

**tom1977** · 07-19-2012, 07:08 AM

try this in D1 and copy down

Formula:

Please Login or Register  to view this content.

**Lozhaze** · 07-19-2012, 08:11 AM

Hi there Tom1977

Thats not how i intended to solve my problem, but it does the job in a different and maybe better way so thank you.

---------- Post added at 07:11 AM ---------- Previous post was at 06:23 AM ----------

Actually in a large column of data i'm getting strange anomalies with that formula, some repeating results and errors.

**tom1977** · 07-19-2012, 08:13 AM

Without sample is hard to say

**Lozhaze** · 07-19-2012, 08:34 AM

Attachment 169098

The cells marked in green (D43,44 and 45) have copied a wrong (and duplicated) cell rather than the cell assigned to the relevant name.

**tom1977** · 07-19-2012, 08:49 AM

Sorry my fault it shoul be:
INDEX($A$1:$A$25,MATCH(C1,$B$1:$B$25,0),1)

and delete attachment I think You have there real personal data

**Lozhaze** · 07-19-2012, 09:37 AM

Thanks, thats perfect.

**Cutter** · 07-19-2012, 09:47 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save