Thread: Excel function help
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Jack Schitt Jack Schitt is offline
external usenet poster
  
Posts: 63
Default Excel function help
I did notice a typo in the original formula;

Should be
=COUNTIF($A1:$F1,A1)1
not
COUNTIF("$A1:$F1,A1)1

You may have already noticed that.


Reply With QuoteReply With Quote