|  | Excel Sort Issue | | |
| | | Guest |  |
|  Posted: Wed Sep 03, 2008 4:34 pm Post subject: Excel Sort Issue |  |
I have groups of data i need to sort by date or type. The data below
would be in excel in columns and rows. How would i sort by date? or by
time?
Date:8/20/08 Time: 5:00
Candy enjoyed?
snickers Y
milky way Y
baby ruth N
Date:8/15/08 Time: 3:00
Candy enjoyed?
3 musket Y
m&m N
baby ruth N
Date:8/30/08 Time: 4:00
Candy enjoyed?
Clark Y
Crunch Y
Hershey N
Thank you for all your help. |
| |
| | | Don Guillett | |
| | Posted: Wed Sep 03, 2008 4:34 pm Post subject: Re: Excel Sort Issue | |
I would suggest re-ordering into 10 columns. Then, sorting is a breeze
A macro can be designed to re-order your groups into the 10 columns.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
<zloki83@gmail.com> wrote in message
news:17ee05cf-c412-4926-ab3b-99976b803574@m36g2000hse.googlegroups.com...
| Quote: | I have groups of data i need to sort by date or type. The data below
would be in excel in columns and rows. How would i sort by date? or by
time?
Date:8/20/08 Time: 5:00
Candy enjoyed?
snickers Y
milky way Y
baby ruth N
Date:8/15/08 Time: 3:00
Candy enjoyed?
3 musket Y
m&m N
baby ruth N
Date:8/30/08 Time: 4:00
Candy enjoyed?
Clark Y
Crunch Y
Hershey N
Thank you for all your help. |
|
| |
| | | Guest | |
| | Posted: Wed Sep 03, 2008 6:05 pm Post subject: Re: Excel Sort Issue | |
On Sep 3, 12:55 pm, "Don Guillett" <dguille...@austin.rr.com> wrote:
| Quote: | I would suggest re-ordering into 10 columns. Then, sorting is a breeze
A macro can be designed to re-order your groups into the 10 columns.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@austin.rr.com<zlok...@gmail.com> wrote in message
news:17ee05cf-c412-4926-ab3b-99976b803574@m36g2000hse.googlegroups.com...
I have groups of data i need to sort by date or type. The data below
would be in excel in columns and rows. How would i sort by date? or by
time?
Date:8/20/08 Time: 5:00
Candy enjoyed?
snickers Y
milky way Y
baby ruth N
Date:8/15/08 Time: 3:00
Candy enjoyed?
3 musket Y
m&m N
baby ruth N
Date:8/30/08 Time: 4:00
Candy enjoyed?
Clark Y
Crunch Y
Hershey N
Thank you for all your help.
|
How would that macro be programed? would it be able to account for if
the number of candies were different for each subject? |
| |
| | | Don Guillett | |
| | Posted: Thu Sep 04, 2008 10:50 am Post subject: Re: Excel Sort Issue | |
| |  | |
There may be too many ifs, ands and buts but I can't tell without seeing the
file. If desired, send to my address below and I'll try to take a look.
Feeling poorly today.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguillett1@austin.rr.com
<zloki83@gmail.com> wrote in message
news:7729f6b1-5386-4011-9e3f-e4e6390cac71@b1g2000hsg.googlegroups.com...
On Sep 3, 12:55 pm, "Don Guillett" <dguille...@austin.rr.com> wrote:
| Quote: | I would suggest re-ordering into 10 columns. Then, sorting is a breeze
A macro can be designed to re-order your groups into the 10 columns.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@austin.rr.com<zlok...@gmail.com> wrote in message
news:17ee05cf-c412-4926-ab3b-99976b803574@m36g2000hse.googlegroups.com...
I have groups of data i need to sort by date or type. The data below
would be in excel in columns and rows. How would i sort by date? or by
time?
Date:8/20/08 Time: 5:00
Candy enjoyed?
snickers Y
milky way Y
baby ruth N
Date:8/15/08 Time: 3:00
Candy enjoyed?
3 musket Y
m&m N
baby ruth N
Date:8/30/08 Time: 4:00
Candy enjoyed?
Clark Y
Crunch Y
Hershey N
Thank you for all your help.
|
How would that macro be programed? would it be able to account for if
the number of candies were different for each subject? |
| |
|
|
