View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
frankfurtjoe frankfurtjoe is offline
external usenet poster
 
Posts: 3
Default find unique records

how do i look through a column of data and create list of the unique entries
not showing the number of duplicates ie apple, pear, orange - and create a
new list of these unique items ? i want to then use this list as a means of
providing a "record count " in a different worksheet. thanks