Thread: Deleting cells with repeated data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
petevang
 
Posts: n/a
Default Deleting cells with repeated data

If I have a list of 10 values in A1 through A10 and cells A5 and A6
contain the same number. How can I use a formula to delete the
repeating cells. I only want to see each number once. Thanks


--
petevang
------------------------------------------------------------------------
petevang's Profile: http://www.excelforum.com/member.php...o&userid=25034
View this thread: http://www.excelforum.com/showthread...hreadid=491061

Reply With QuoteReply With Quote