Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding matching cells (Excel 2007)
COL A has 1,313 cells whose contents look like this:
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.programming
|
|||
|
|||
finding matching cells (Excel 2007)
I suppose this would do it:
=IF(A1=LEFT(B1,11),"Match","") Do you need a macro? Ryan--- -- RyGuy "gcotterl" wrote: COL A has 1,313 cells whose contents look like this: 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
finding matching cells (Excel 2007)
another way:
=IF(ISERROR(MATCH(LEFT(B1,11),$A$1:$A$1313,)),""," match") then use autofilter if need be On 6 Mar, 07:02, gcotterl wrote: COL A has 1,313 cells whose contents look like this: 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 | |||
Finding matching cells | Excel Discussion (Misc queries) | |||
Finding matching cells | Excel Discussion (Misc queries) | |||
Finding cells with matching data | Excel Programming | |||
Matching cells (Excel 2007) | Excel Programming | |||
finding matching cells in worksheets | Excel Worksheet Functions |