Allow me to clarify the SalaryType column in my above post:


In my solution I assumed from your first post that this column will
contain intergers- unknown at this point- but you wanted to assign one
of two categories to each of these entries.

In my code, each entry will be assigned a value of zero if it's 1 to 3
or a value of 5 if the entry is above 3.

HTH
Paul


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/