Actually, I've just re-read your last sentence, and I think you'll
want to change the numbers around so that verbal is 1 etc.

Incidentally, you could save doing the sort twice by joining together
the employee's last name and first name into one column, so that you
only have 3 sort keys.

Hope this helps.

Pete

On Aug 2, 12:12 am, Pete_UK wrote:
You should introduce a helper column and allocate a code for the
descriptions of severity. You might like to set up a small table
somewhere (eg X1:Y4) like this:

verbal 7
written 5
final written 3
termination 1

then you could use a VLOOKUP formula to "translate" the description to
its value in the helper column. You would then use the helper column
as one of your sort keys. Note that I've left gaps in the numbers in
case you introduce other descriptions in the future, but you could
just use 1 to 4.

Hope this helps.

Pete





This worked :) Thanks! But... I forgot... I actually need it to sort
not alphabetically but by an order considered "in severity". The
database is listing levels of corrective action for employees... the
levels are verbal, written, final written and then termination.

Is there a way to use this to sort first by the 3 columns I had before
(which, for reference, are the supervisor name, last name of employee,
first name of employee - respectively) and then sort it by the level
of corrective action where verbal is the first one on the list,
written is second, final written is third and termination is last in
order?

Thanks! :)- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -