View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Writing a macro to bring back distinct value

Hi
see:
http://www.cpearson.com/excel/duplic...tractingUnique
-----Original Message-----
I have a spreadsheet contains values in columns H, I and

J.

I do not want the data in columns I and J so I want them
deleted, however, I do want some of the data in column

H.
A number of the values appear more than once but all i
want is a list of distinct values from that row.

Any ideas as to how to go about this ?

Thanks
.