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?

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?