View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default Counting and duplicates

Hi,

I have a column of numbers with duplicates. so the numbers might be


A1 = 33, A2=1221, A3=4, A4=4, A5=4, A6=8392,....

I want to display the numbers without the duplicates - in column B.

Do you know how to do this?

Thanks for your help.