Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question - How to group unique objects in Excel
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Question - How to group unique objects in Excel
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: http://www.contextures.com/xlCondFor...html#Duplicate bradsaxon wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I get Excel to automatically group items? | Excel Discussion (Misc queries) | |||
Unable to close excel as a group from the task bar | Excel Discussion (Misc queries) | |||
How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
Weird question on filling in typing in excel | Excel Discussion (Misc queries) | |||
"Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) |