View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mondo Mondo is offline
external usenet poster
 
Posts: 6
Default one time appearance on the list

Hi,

I am sometimes working with list of materials, where I have a line for each
change on the material. That means that sometimes there can be lots of lines
for the same material. For example there has been 5000 changes on 2000
materials. That means that in my report I have 5000 lines. How can I
eliminate those extra 3000, to just get the list of all the materials with a
change(s) once on the list?

Thank you