hi, Herbert !

Excel 2003
No code, easy formulas.
http://freefilehosting.net/download/41e93

working from excel 97 <vg

how would the names technic perform (as OP commented)...
" ... my list is over 30,000 rows with a few thousand different companies." -?-

regards,
hector.