Ken -

Like mine, only better.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Ken Johnson" wrote in message
ups.com...

Hi jfcby,

If your data starts in A1 then fill the following formula down column B

=MATCH(A1,{"H","WH","O","B","AN"},0)

Ken Johnson