Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
(Please Help) Merge coloms based on equal rows with information
Hi
I have a sheet with this information Card# Name Surname 1 A Alast 2 B Blast 3 C Clast 4 D Dlast and another sheet with this information Student# Name Surname 22 B Blast 11 A Alast 33 C Clast 55 E Elast I need to extract Card# and Student# by comparing Name and Surname and get this list Card# Student# Name Surname 1 11 A Alast 2 22 B Blast 3 33 C Clast many thanks in advance |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
(Please Help) Merge coloms based on equal rows with information
Add a formula to column D of Sheet1 and Sheet2 which concatenates the
names together, i.e. in D2 of both sheets: =B2&C2 and copy this down as far as needed. Then in Sheet3, assuming you have the names in columns C and D, put this formula in A2: =INDEX(Sheet1!A:A,MATCH(C2&D2,Sheet1!D:D,0)) and this in B2: =INDEX(Sheet2!A:A,MATCH(C2&D2,Sheet2!D:D,0)) Then copy these down as far as required. Hope this helps. Pete On Aug 22, 10:38*am, khers wrote: Hi I have a sheet with this information Card# * Name * *Surname 1 * * * * * * * A * * * * * * * Alast 2 * * * * * * * B * * * * * * * Blast 3 * * * * * * * C * * * * * * * Clast 4 * * * * * * * D * * * * * * * Dlast and another sheet with this information Student# * * * *Name * *Surname 22 * * * * * * *B * * * * * * * Blast 11 * * * * * * *A * * * * * * * Alast 33 * * * * * * *C * * * * * * * Clast 55 * * * * * * *E * * * * * * * Elast I need to extract Card# and Student# by comparing Name and Surname and get this list Card# * Student# * * * *Name * *Surname 1 * * * * * * * 11 * * * * * * *A * * * * * * * Alast 2 * * * * * * * 22 * * * * * * *B * * * * * * * Blast 3 * * * * * * * 33 * * * * * * *C * * * * * * * Clast many thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I count MTD coloms? | Excel Worksheet Functions | |||
Fixing the number of Coloms and rows. | Excel Discussion (Misc queries) | |||
Merge rows into one based on value | Excel Discussion (Misc queries) | |||
Is there a way to hide worksheets and/or rows/columns based on information enter into a particular cell of range of cells? | New Users to Excel | |||
Looking up information based on Columns and Rows | Excel Worksheet Functions |