I have data that I need to sort by groups.
Like:
xxxx yyaa
xxxx abcc
I need to sort to find all the yy's and count and then all the ab's and count?
I have data that I need to sort by groups.
Like:
xxxx yyaa
xxxx abcc
I need to sort to find all the yy's and count and then all the ab's and count?
You can sort your data by group and then use subtotals count the records at
each change in group.
After sorting, click DATA and select SUBTOTALS.
In the subtotals dialog box, select your group column for the AT EACH CHANGE
IN value, select COUNT as the USE FUNCTION value, and select the group column
as the column to count as the ADD SUBTOTAL TO value.
--
Kevin Backmann
"Dan S" wrote:
> I have data that I need to sort by groups.
>
> Like:
>
> xxxx yyaa
> xxxx abcc
>
> I need to sort to find all the yy's and count and then all the ab's and count?
Thanks. The only problem is the group with xxxx is really AUCT or NESN and
not xxxx, so when I sort it just puts them in alphabetical order and is still
no help.
"Kevin B" wrote:
> You can sort your data by group and then use subtotals count the records at
> each change in group.
>
> After sorting, click DATA and select SUBTOTALS.
>
> In the subtotals dialog box, select your group column for the AT EACH CHANGE
> IN value, select COUNT as the USE FUNCTION value, and select the group column
> as the column to count as the ADD SUBTOTAL TO value.
>
>
> --
> Kevin Backmann
>
>
> "Dan S" wrote:
>
> > I have data that I need to sort by groups.
> >
> > Like:
> >
> > xxxx yyaa
> > xxxx abcc
> >
> > I need to sort to find all the yy's and count and then all the ab's and count?
Well, why not separate out the two characters you need, i.e. enter:
= LEFT(B1,2)
in cell C1 and copy down. Now sort your data (plus column C) using
column C - you can always delete this column if you have no further
need for it.
Hope this helps.
Pete
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks