Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to compare and extract data in two columns
Hi,
I have First Name, Last Name, UserID from one file. And again First Name, Last Name only from second file. I need to compare the two data sets so as to extract UserIDs. e.g (The data is in same worksheet) FirstName LastName UserID FirstName LAstName John Adam Jadam Sara Kent Bill Gate Bgate John Adam ..... ... I need to extract names along with UserIDs that match. Like: John Adam Jadam Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to compare and extract data in two columns
FirstName LastName UserID FirstName LAstName
John Adam Jadam Sara Kent Bill Gate Bgate John Adam Assuming the above's in cols A to E, data from row2 down Put in F2's formula bar, then press CTRL+SHIFT+ENTER to confirm the formula (ie array-enter): =index(c$2:c$100,match(1,(a$2:a$100=d2)*(b$2:b$200 =e2),0)) Copy F2 down -- Max Singapore http://savefile.com/projects/236895 Downloads:16,700 Files:356 Subscribers:53 xdemechanik --- "SK" wrote: I have First Name, Last Name, UserID from one file. And again First Name, Last Name only from second file. I need to compare the two data sets so as to extract UserIDs. e.g (The data is in same worksheet) FirstName LastName UserID FirstName LAstName John Adam Jadam Sara Kent Bill Gate Bgate John Adam .... ... I need to extract names along with UserIDs that match. Like: John Adam Jadam Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract unique data across columns in a row. | Excel Discussion (Misc queries) | |||
Excel 2002 : How to extract data from columns ? | Excel Discussion (Misc queries) | |||
Extract & compare data on different worksheets | Excel Discussion (Misc queries) | |||
Extract data and print in columns | Excel Discussion (Misc queries) | |||
Extract data based on critera from three columns | Excel Discussion (Misc queries) |