Group items

[Guest]

Hi:

Is there a function to group items
from (for example) column A to another
part of a workbook or sheet. I’m trying
to achieve something like the following.

A C
1 apples apples
2 oranges oranges
3 grapes grapes
4 apples
5 oranges
6 grapes
7 apples
8 oranges
9 grapes

Thanks

TK

 

[Phil Webb]

You can accomplish this by using Excel's filtering tools. First, select a
cell in the list to be filtered and then turn on autofilter
(Data/FilterAutofilter). Next, select Advanced Filter (Data/Filter/Advanced
Filter). In the dialog box, check the Unique Records Only. If you want to
produce a filtered list separate from your original list, click the option
labeled, "Copy to another location".

HTH
Phil Webb

 

[Gord Dibben]

TK

See Debra Dalgleish's site for filtering and extracting unique items from a
list.

http://www.contextures.on.ca/xladvfilter01.html#FilterUR

Gord Dibben Excel MVP

 

[Guest]

Thanks Phil, Gord

Phil's suggestion on advance filters work but exposed the problem that
my actual list has blanks. On Gord's website suggestion I found an
example that dealt with blanks in the list. How lucky can you get with
one post.

Thanks again: