Hi,

Not really got time to check it but won't something along the lines
of:

insert a column next to column A in sheet 1 (you can hide it later). in
cell 1 of inserted column write '=right(A1,3)', drag down the rest of
the column

This will retrieve the last three digits of the code in column A.

Then wherever you want the count write '=countif(B2:B3000,241)'.

You could probably do it with the countif function from the start but
it would be hard.


--
coa01gsb
------------------------------------------------------------------------
coa01gsb's Profile: http://www.excelforum.com/member.php...o&userid=31214
View this thread: http://www.excelforum.com/showthread...hreadid=563194