S

#### sparklyballs

i do this on a weekly basis , putting each weeks new data in a new

worksheet.

i need to be able to find the most common occuring part no. across

these worksheets.

the problem i have that these part numbers have various different

formats

some are just plain numbers eg 1234

some have a stroke and a number after them to denote a left and right

pair of the same part eg 1234/1.

the last type has the stroke for left and right, and an additional

stroke and a letter to denote revision changes to parts eg 1234/1/A

the part numbers are anywhere from 2 digits up to 7 digits.

is there a way to find which part occurs most so that i can then inform

the right people that they need to concentrate on the particular part.

the part numbers are always in the same column on each worksheet.