Thread: compile list
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
smonsmo smonsmo is offline
external usenet poster
 
Posts: 20
Default compile list

I have a column c2:c294 that contains Job names. There may be identical
entries. I need to compile a list of all entries without duplicates or blank
cells. This will need to be done automatically. Data sort or a macro are
the obvious choices however in this case will not serve.
Any Ideas?
Thanks