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 search a column of data which contains for instance multiple numbers
of headings, find each unique record item (ie apple , pear, orange) and then
display a list of each type (no duplicates) in a new range of cells. I will
then be able to use this record list as a means of providing a "record type
count" in a different worksheet. Thanks