Matching Columns and providing Totals

[jerry]

Hello again Excellers

Another problem im having im trying to match two columns of drawing structure numbers and providing totals of how many times they match.

however though there are differences in the two columns because of data entry is it possible to match the data based on numbers and letters but if theres a space and letter difference to ignore it

i have tried vlookup and and other macros i seem to be getting lost not hard to do really im quite simple

anyways a little bit of help would be appreciated

[HansV]

Try this formula in C2:

=COUNTIF($A$2:$A$1000,B2&"*")

(Adjust the range A2:A1000 as needed)

You can fill the formula down from C2.

[jerry]

THANKS AGAIN HANSV FOR SAVING MY BACON

anytime yourr in sydney et me know beers are my shout

Regards