Thread: allowing each value to be used once
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd P Bernd P is offline
external usenet poster
  
Posts: 806
Default allowing each value to be used once
Hello Jacob,

If the OP would not like to highlight the first instance then I would
simply suggest
=COUNTIF($A1:A1,A1)1
:-)

Regards,
Bernd
Reply With QuoteReply With Quote