Thread: Elimnating subsequent cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Elimnating subsequent cells
Since the first item will always be in the result list make B1 equal
A1.
Put the following formula into cell B2 and copy it down:

=IF(ISERROR(MATCH(A2,$A$1:A1,0)),A2,"")

Reply With QuoteReply With Quote