View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Greg Greg is offline
external usenet poster
 
Posts: 331
Default Consolidate mutiple names in Column

Hi, I have a column that has mutliple names in it like shown in the example
below.

M Arque
J Amati
J Amati
M Arque
T Edwards
J Hall
J Hall
M Desai
M Desai

Is it possible to consolidate the name in another column to count the names
as one entry?