Excel Sort Issue

  • Thread starter Thread starter zloki83
  • Start date Start date
Z

zloki83

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.
 
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.
 
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.
Click to expand...

How would that macro be programed? would it be able to account for if
the number of candies were different for each subject?
 
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
(e-mail address removed)
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.
Click to expand...

How would that macro be programed? would it be able to account for if
the number of candies were different for each subject?
 
Back
Top