View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TonyD TonyD is offline
external usenet poster
 
Posts: 29
Default Cell Blank if duplicate value in previous cell

I want to copy date from one worksheet into another with copy past special as
a "value" from two columns. However if the department is the same in cell B1
as A1 I want B1 to be blank. Is there any one of doing this?