Another - but slightly different - 'compare 2 columns' question

[CrankyLemming]

I'm not sure how to do this. Any advice would be greatly appreciated.
I've looked at Chip Pearson's site, and can see how to do this if the
numbers in each column were the same format, but this is slightly more
awkward.

Column A contains a list of reference numbers, as does column C. The
numbers in column A are formatted as follows: AA123456, whilst those
in column C are similar, but have an additional letter at the end:
AA123456A (National Insurance numbers, for any Brits reading this).

Many, but not all, of the numbers in A will form most of a number
somewhere in column C. What I need to do is find those records in
column C whose first 8 digits match a number in column A, and record
these in another column (or otherwise highlight them; I'm easy
).

I can do this if the return is based on column A, but it's the
nine-digit numbers I need to be able to list seperately.



Thanks in advance

Steve

 

[Frank Kabel]

Hi
maybe use a helper column D with the formula
=LEFT(C1,8)
and then use the techniques described on Chip's page