On Aug 2, 10:28 am, Pete_UK wrote:
You could put the table on a separate sheet. However, as you only have
four items you can build these into the formula like so:

=LOOKUP(D2,{"final written","termination","verbal","written"},
{3,4,1,2})

I am assuming that you have these values in column D - just copy the
formula down your helper column and then sort on this column.

You could put a comment in each cell (or use Data Validation - input
message) to tell your Users about Last Name first, but what I was
suggesting is to leave your columns as they are and to use another
helper column (which could be hidden from view) - in this column you
can just join the Last Name with the First Name using &, and then have
this as one sort field.

If you don't join them then I would suggest that you do a sort using
Last Name and First Name columns as the sort keys first, and then do a
sort on column F and the helper column for actions.

Hope this helps.

Pete

On Aug 2, 1:15 pm, wrote:





As for the table option - can I put the table on a separate sheet with
the other info for the drop down boxes?

The reason I am separating first and last name is that if I leave it
as one box, I imagine people will inevitably do it incorrectly by
putting first name, last name while others put last name, first
name... there's no way to ask last name then first name within one
cell is there?- Hide quoted text -

- Show quoted text -- Hide quoted text -

- Show quoted text -

Maybe I should mention that I don't know a whole lot about excel and
we should go from there :)

Ok... I love the idea of being able to put Last Name, First Name
linked together - can you explain (simply?) how to do that?

Also... in the D column where level is - there is already a validation
in place (a drop down box that contains the 4 choices of corrective
action). Is it possible to have this validation as well as the Lookup
tool? I was trying to do the VLookup thing and it wouldn't work
because there is already validation there? But, it might be that I
don't understand how to do it... I was reading from contextures.com to
try and figure it out but... most of it's "greek to me"... so I get
lost trying to understand what goes where...

Maybe more info is needed...

I'm not sure if you need all the columns or not - but...

A - Rep ID
B - Last Name
C - First Name
D - Level of C.A.
E - Date Issued
F - Supervisor
G - Delivered To
H - Date Delivered
I - Hire Date

So, if we have 200 people listed here, I want it to sort by the
supervisor first - all of John Doe's people grouped together... but,
within John Doe's list of people, I want the people on verbal's to be
on top, then written, then final written, then termination... once
those are grouped accordingly, I want them sorted by last name then
first name...

So much! Sorry :) Can you help? :)