Advanced Sortting Issue
 

Please Help!!! I pretty good with Excell, but I don't really know the lingo
so bear with me
Here is what I'm dealing with. I have lets say something that looks like
this below.

A B C D E F G H I J K L M N O P Q R S
Employee Position Employee # Rating
Bob Smith Cheif 1234567 Unlimited
Document Orig Date Exp Date Comment
CPR 1-1-1999 1-1-2002 none
MMD 1-3-1998 1-4-2005 none
First Aid 1-3-1999 1-3-2002 none

Now lets say I have 10 Employee's and want to keep track of when different
"Documents" "Exp". These are merged cells and I can't sort a mreged cell for
some reason.
Now on to the bigger question. Lets say I have 10 of these "fields" (10 of
the same setup as above copied below eachother) I want to sort each
"Employee" by the soonest expiration date.

Thank You
Sean DeBruler

Advanced Sortting Issue
 

First of all, unmerge those cells. I suggest you workaround it, one
possibly being align as Center Across Selection if desired. And you can
sort by up to 3 different criterions natively if you'd like. Select your
data/column | Data | Sort, pick your criteria(s).

Is this what you're talking about?

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.


"Sean DeBruler" wrote in message
...
Please Help!!! I pretty good with Excell, but I don't really know the
lingo
so bear with me
Here is what I'm dealing with. I have lets say something that looks like
this below.

A B C D E F G H I J K L M N O P Q R S
Employee Position Employee # Rating
Bob Smith Cheif 1234567 Unlimited
Document Orig Date Exp Date Comment
CPR 1-1-1999 1-1-2002 none
MMD 1-3-1998 1-4-2005 none
First Aid 1-3-1999 1-3-2002 none

Now lets say I have 10 Employee's and want to keep track of when different
"Documents" "Exp". These are merged cells and I can't sort a mreged cell
for
some reason.
Now on to the bigger question. Lets say I have 10 of these "fields" (10
of
the same setup as above copied below eachother) I want to sort each
"Employee" by the soonest expiration date.

Thank You
Sean DeBruler

Advanced Sortting Issue
 

Thanks for the info Zack.
I have unmreged all of the cells. now I still have the same "field" for
each "employee" but I want excell to sort automaticly. Because in reality
It's more like 200 employee's. Not just each employee individualy, but eaach
"field" as well. Can this be done.

"Zack Barresse" wrote:

First of all, unmerge those cells. I suggest you workaround it, one
possibly being align as Center Across Selection if desired. And you can
sort by up to 3 different criterions natively if you'd like. Select your
data/column | Data | Sort, pick your criteria(s).

Is this what you're talking about?

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)
To email, remove the NO SPAM. Please keep correspondence to the board, as
to benefit others.


"Sean DeBruler" wrote in message
...
Please Help!!! I pretty good with Excell, but I don't really know the
lingo
so bear with me
Here is what I'm dealing with. I have lets say something that looks like
this below.

A B C D E F G H I J K L M N O P Q R S
Employee Position Employee # Rating
Bob Smith Cheif 1234567 Unlimited
Document Orig Date Exp Date Comment
CPR 1-1-1999 1-1-2002 none
MMD 1-3-1998 1-4-2005 none
First Aid 1-3-1999 1-3-2002 none

Now lets say I have 10 Employee's and want to keep track of when different
"Documents" "Exp". These are merged cells and I can't sort a mreged cell
for
some reason.
Now on to the bigger question. Lets say I have 10 of these "fields" (10
of
the same setup as above copied below eachother) I want to sort each
"Employee" by the soonest expiration date.

Thank You
Sean DeBruler