Prev: HELP! Lookup
Next: How do I create unique pivot tables from the same data
From: JGAVIGAN on 9 Apr 2010 10:21

--
JG
From: Dave Peterson on 9 Apr 2010 10:33
If you used data|subtotals to apply the subtotals, then use the outlining
symbols to the left to hide the detail rows and sort the data by the field you
want.

JGAVIGAN wrote:
>
> --
> JG

--

Dave Peterson
From: dlw on 9 Apr 2010 10:34
go to the view where you just see the subtotals, highlight what you want to
sort, on the menu bar: Edit / Go to / Special / Visible Cells Only
then Edit / Copy, then paste into another sheet. You can now sort that as
usual

"JGAVIGAN" wrote:

>
> --
> JG
 | 
Pages: 1
Prev: HELP! Lookup
Next: How do I create unique pivot tables from the same data