Thread: How to replace numbers in sequence without sorting?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
geniusideas geniusideas is offline
external usenet poster
  
Posts: 70
Default How to replace numbers in sequence without sorting?
Hi,

I need to replace those numbers duplicate so that it follow in
sequence for example:

In Column A I have these number
2,1,5,3,3,6,8,8 (Before)
2,1,5,3,4,6,8,9 (after)
Anyone got idea how to do it with macro?
Please.Thanks
Reply With QuoteReply With Quote