Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding matching cells
COL A has 1,313 cells whose contents look like:
107211009-1 114650003-4 122413021-6 COL B has 987,601 cells whose contents look like this: 008100465-2 01 58.86 008100465-2 02 58.86 008100493-7 01 16.12 How do I find the cell(s) in COL B whose eleven left-most characters match the contents in the cells in COL A? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding matching cells
Hi,
In column C enter the following Array formula: =OR(LEFT(B1,11)=$A$1:$A$1313) to make this an array press Shift+Ctrl+Enter to enter it. Copy it down as far as needed. Then you could add an auto filter and filter on all cells in column C with TRUE. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "GARY" wrote: COL A has 1,313 cells whose contents look like: 107211009-1 114650003-4 122413021-6 COL B has 987,601 cells whose contents look like this: 008100465-2 01 58.86 008100465-2 02 58.86 008100493-7 01 16.12 How do I find the cell(s) in COL B whose eleven left-most characters match the contents in the cells in COL A? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Not finding matching value in vlookup | Excel Worksheet Functions | |||
Finding matching values | Excel Worksheet Functions | |||
Finding matching cells between two workborks and updating cell con | Excel Worksheet Functions | |||
Finding One Value, Matching Three Criteria | Excel Discussion (Misc queries) | |||
finding matching cells in worksheets | Excel Worksheet Functions |