| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
finding multiple code dates for multiple item number
I have a file that has item numbers in column A for multiple sites in sheet 1
(A9:A7425). In column E in sheet 1 are the code dates for those item numbers (E9:E7425). The item number may be listed up to 55 times for all the code dates that it has. The code date may be all numeric or alphanumeric. On Sheet 2 I have in Column A the item numbers for only 1 site (A2:A113). I need to find all the code dates from sheet 1 that match each item number in sheet 2. Not all the item numbers from sheet 2 will be listed in sheet 1. Is there a way to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding a number within a text and numbers for multiple rows | Excel Worksheet Functions | |||
| Delete Blank Rows Code - Multiple Worksheets - Multiple Documents | Excel Discussion (Misc queries) | |||
| Finding Office and Last Code Used on Acct Based on Multiple Critie | Excel Discussion (Misc queries) | |||
| Retrieve multiple dates, from a week number? | New Users to Excel | |||
| Simple Way to Count the Number of Duplicate Dates on Multiple Worksheets | Excel Discussion (Misc queries) | |||
Threaded Mode
