Data Sort

[Colorado Greenskeeper]

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.

 

[Pecoflyer]

I am wondering how to sort cells/rows in groups.
Each group will contain many rows containing product info for a give
day.
Each group will also contain ONE "Total" row i.e. price, tota
nutrients, etc.
Even though each row in the group will have the same date, sorting b
date
changes the order within the group (there is no column that ha
asceding data
for Excel to look for a second condition for the sort) usually puttin
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 nee

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste

 

[Roger Govier]

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