matching columns

  • Thread starter Thread starter Peter
  • Start date Start date
P

Peter

I want to know if there is a formula I can use that would match up the
same names from the 2 columns and put it in the same row with their
results (i don't know if i'm explaining this correctly), instead of
doing it manually. See below:
Thanks!

A B C D
Charles 1 Peter 4
Peter 2 Xavier 3
Allison 3 Kim 7
Xavier 5 Nancy 6
Nancy 6 Edward 8
Edward 7 Pedro 9
Susan 8 Carlos 9
Kim 9


This is what I want it to look like:

A B C D
Charles 1
Peter 2 Peter 4
Allison 3
Xavier 5 Xavier 3
Nancy 6 Nancy 6
Edward 7 Edward 8
Susan 8
Kim 9 Kim 7
Carlos 9
Pedro 9
 
Peter said:
I want to know if there is a formula I can use that would match up the
same names from the 2 columns and put it in the same row with their
results (i don't know if i'm explaining this correctly), instead of
doing it manually. See below:
Thanks!

A B C D
Charles 1 Peter 4
Peter 2 Xavier 3
Allison 3 Kim 7
Xavier 5 Nancy 6
Nancy 6 Edward 8
Edward 7 Pedro 9
Susan 8 Carlos 9
Kim 9


This is what I want it to look like:

A B C D
Charles 1
Peter 2 Peter 4
Allison 3
Xavier 5 Xavier 3
Nancy 6 Nancy 6
Edward 7 Edward 8
Susan 8
Kim 9 Kim 7
Carlos 9
Pedro 9
Click to expand...
In column c you can use the formula "vlookup(A1,$A$1:$A$8,1,0) now you will
get the name in column c just drag it till the last row of names. then filter
the not applicables and copy paste the names in column A manually to colunn c.
 
Back
Top