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:
"Gord Dibben" wrote:
TK
See Debra Dalgleish's site for filtering and extracting unique items from a
list.
http://www.contextures.on.ca/xladvfi....html#FilterUR
Gord Dibben Excel MVP
On Tue, 31 Aug 2004 17:27:02 -0700, "TK" wrote:
Hi:
Is there a function to group items
from (for example) column A to another
part of a workbook or sheet. Im 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