Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with a sort please
I have a sheet that I would like to sort. It has the Date in column A, and a Start Time in column B, with another 5 columns of data. It is for multiple employees, so what I would like to do is sort it by date, then start, but limit the sort to be by them employee. Column F has a count that changes when the employee does.
something along the lines of do sort until sortcount = employeenumber sort on column a, then column b as long as sortcount = cell f,x (x is employeenumber) sortcount=sortcount + 1 loop I hope that I was able to explain this. Thanks. --------------= Posted using GrabIt =---------------- ------= Binary Usenet downloading made easy =--------- -= Get GrabIt for free from http://www.shemes.com/ =- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating workbook with an alpha sort sheet and a numeric sort shee | Excel Discussion (Misc queries) | |||
sort function for dates does not sort properly in Office 2007 Exc. | Excel Worksheet Functions | |||
Pls. reply Sort Data and copy to next coulmn when sort order chang | Excel Programming | |||
Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
sort (on part of) string - originally posted under Tricky Sort | Excel Programming |