| 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 |
| 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 | |||
Threaded Mode
