Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding matching numbers from 1 worksheet in another and with a tw
I have a to find serial numbers of multiple types of equipment from one work
book that appear in another workbook. The serial numbers range from 4 digits to 15 digits or more. The major problem for me is, in the spreadsheet I am looking in, often there are multiple serial numbers in one cell separated by a symbol or symbols. These symbols are rarely the same. VLOOKUP is no use in this instance. I realize I could just use the find button and type in each serial number but with 20K lines it would take an eternity. (my issue now) I need to identify the matches somehow either by changing a font or placing a Y in a column something that would do this without going line by line. Any help would be appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding matching numbers from 1 worksheet in another and with a tw
For each id you are looking form presuming your id is in a worksheet
startying on cell A2 and your list is on sheet1 A2 - A30000 =SUMPRODUCT(--(ISERROR(SEARCH(A2,Sheet1!A2:A30000))=FALSE)) "Evil with a K" wrote: I have a to find serial numbers of multiple types of equipment from one work book that appear in another workbook. The serial numbers range from 4 digits to 15 digits or more. The major problem for me is, in the spreadsheet I am looking in, often there are multiple serial numbers in one cell separated by a symbol or symbols. These symbols are rarely the same. VLOOKUP is no use in this instance. I realize I could just use the find button and type in each serial number but with 20K lines it would take an eternity. (my issue now) I need to identify the matches somehow either by changing a font or placing a Y in a column something that would do this without going line by line. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for finding matching numbers | New Users to Excel | |||
Finding matching cells | Excel Discussion (Misc queries) | |||
Finding matching numbers in different rows. | Excel Worksheet Functions | |||
Not finding matching value in vlookup | Excel Worksheet Functions | |||
Finding One Value, Matching Three Criteria | Excel Discussion (Misc queries) |