View Single Post
  #3   Report Post  
txheart txheart is offline
Junior Member
 
Posts: 21
Default

Quote:
Originally Posted by wickedchew View Post
The COUNTIF function is:

=COUNTIF(Range, Criteria)

Range is where you have a list to be checked and Criteria is what needs to be looked for in your list.
According to your reply, if the don't duplicate data is in range E4:E200 my formula should be =COUNTIF($E$4:$E$200,E4)=1
correct?

Thank you for helping Wicked!

~Ky



Thank you for your help Wicked