Group items

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
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:
 
Back
Top