software

I have an Excel worksheet. There is a column with duplicate entries. I want
to be able to group by unique entries, but still keep the information tied to
the other columns. For example:

Column 1 Column2
Primary CE CA85
Secondary CE CA85
Secondary CE CA85
CE Group CK11

I want to group on Column 2 so that CA85 appears once, but there are still 3
entries in Column1.

Essentially, what I am looking for is an output of unique items similar to
what is displayed in the drop down list of column 2 if I was to use the Auto
Filter capability.

Any help this newsgroup could provide is much appreciated.

Thanks!

Brad

I don't quite understand what you want, but if your data is sorted nicely, you
could use Data|subtotal to group by that column (and even include subtotals for
any column you want).

Then you could use format|conditional formatting to hide the duplicates in that
column. (They'll still be there, but it'll look like they're gone.)

See Debra Dalgleish's site for instructions:
www.contextures.com/xlCondFor...html#Duplicate

bradsaxon wrote:
gt;
gt; I have an Excel worksheet. There is a column with duplicate entries. I want
gt; to be able to group by unique entries, but still keep the information tied to
gt; the other columns. For example:
gt;
gt; Column 1 Column2
gt; Primary CE CA85
gt; Secondary CE CA85
gt; Secondary CE CA85
gt; CE Group CK11
gt;
gt; I want to group on Column 2 so that CA85 appears once, but there are still 3
gt; entries in Column1.
gt;
gt; Essentially, what I am looking for is an output of unique items similar to
gt; what is displayed in the drop down list of column 2 if I was to use the Auto
gt; Filter capability.
gt;
gt; Any help this newsgroup could provide is much appreciated.
gt;
gt; Thanks!
gt;
gt; Brad

--

Dave Peterson