My spreadsheet has 5 columns: NAME, DATE, ITEM, COST, TOTAL, where TOTAL is given only on last row for a particular NAME & DATE. Names can also be reused with different dates.
Jane 6/11 box $5
Jane 6/11 car $15 $20
Sam 7/2 box $2
Sam 7/2 kite $5 $7
Brad 8/1 kite $5
Brad 8/1 car $10 $15
If I sort by TOTAL I get:
Jane 6/11 car $15 $20
Brad 8/1 car $15 $15
Sam 7/2 kite $5 $7
Jane 6/11 box $5
Brad 8/1 kite $5
Sam 7/2 box $2
What I want is:
Jane 6/11 box $5
Jane 6/11 car $15 $20
Brad 8/1 kite $5
Brad 8/1 car $10 $15
Sam 7/2 box $2
Sam 7/2 kite $5 $7
This is simplistic here, but I have thousands of rows and additional columns (again some with info, others without for each row). I don't do VBA or similar. I've thought I've adding a new column before the name and assigning a number/alpha code, but nothing I've tried has produced my desired result when I sort (using multi-levels).
Bookmarks