| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
Matching !!
Hi,
I have two worksheets - Sheet1 and Sheet2 Sheet 1 Col A Col B Codes A/C Numbers Pacific 145762 Atlantic 345782 Monte carlo 478562 Pacific 785 Sheet 2 Col A Codes ( unique ) Pacific Atlantic Monte Carlo I am using Excel 2007, I need to match Sheet 2 Col A data with Sheet1 Col A data, if any match found i need result in Col B of Sheet 2. If there are more than one then the A/C numbers to be separated by comma ( eg., 145762,785) Sheet 1 has Approximately 1.5 Lakh Row Sheet 2 has only 10,000 rows. Please help me guys.... |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help me to first row matching First date and last row matching lastrow | Excel Programming | |||
| Matching identical data using data only once in the matching proce | Excel Discussion (Misc queries) | |||
| Help with Matching Text Fields - Then Moving the Matching Cells Side by Side | Excel Discussion (Misc queries) | |||
| Matching rows in 2 sheets and copying matching rows from sheet 1 t | Excel Programming | |||
| Matching data and linking it to the matching cell | Links and Linking in Excel | |||
Threaded Mode
