Thread: Excel Validation Help Needed
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
  
Posts: 5,302
Default Excel Validation Help Needed
Hi Sam,

Small typo:

Change the formula:

=COUNTIF(C$1:C$1000,C1)1

to:

=COUNTIF($C$1:$C$1000,$C1)1

---
Regards,
Norman




Reply With QuoteReply With Quote