View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mik Mik is offline
external usenet poster
 
Posts: 42
Default List cell content without duplication or blanks

Hello, looking for some help with the following:-
I have a list of names within Column A, some of which are repeated
numerous times.
What i require, is to list in Column B each of the names shown in
Column A (once only), so those names that are repeated, are only
displayed once.

Col A Col B

A A
B B
C C
B D
D E
E F
A
A
F