Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Data Sort
I am wondering how to sort cells/rows in groups.
Each group will contain many rows containing product info for a given day. Each group will also contain ONE "Total" row i.e. price, total nutrients, etc. Even though each row in the group will have the same date, sorting by date changes the order within the group (there is no column that has asceding data for Excel to look for a second condition for the sort) usually putting the "Total" at the top of the group, which screws up the calculations. I also need to be able to enter/change data in the groups. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Data Sort
Colorado Greenskeeper;243005 Wrote: I am wondering how to sort cells/rows in groups. Each group will contain many rows containing product info for a given day. Each group will also contain ONE "Total" row i.e. price, total nutrients, etc. Even though each row in the group will have the same date, sorting by date changes the order within the group (there is no column that has asceding data for Excel to look for a second condition for the sort) usually putting the "Total" at the top of the group, which screws up the calculations. I also need to be able to enter/change data in the groups. As far as I understand your needs, a Pivot Table might be what you need -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=67742 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Data Sort
Hi
Without seeing your data set it is difficult to advise. But supposing you had something Representing group in column A, an d your word "Total " appeared in column B In an unused column you could use a formula like =A2&IF(B2="Total","Total","") and copy down Now, when you sort, sort using the new column then date -- Regards Roger Govier "Colorado Greenskeeper" wrote in message ... I am wondering how to sort cells/rows in groups. Each group will contain many rows containing product info for a given day. Each group will also contain ONE "Total" row i.e. price, total nutrients, etc. Even though each row in the group will have the same date, sorting by date changes the order within the group (there is no column that has asceding data for Excel to look for a second condition for the sort) usually putting the "Total" at the top of the group, which screws up the calculations. I also need to be able to enter/change data in the groups. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data, sort option is grayed. how to sort on a column? | Excel Discussion (Misc queries) | |||
Help to sort out filtered data from the data contained in another sheet of the same workbook | Excel Worksheet Functions | |||
I want to convert word column data to excel row data to sort addre | Excel Discussion (Misc queries) | |||
data sort is not including all columns in sort | Excel Discussion (Misc queries) | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) |