View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
tom[_7_] tom[_7_] is offline
external usenet poster
 
Posts: 24
Default Cells Contents Anywhere Else in Column

=COUNTIF(A1:A300,A1)1

Interesting. I am so Formula ignorant, and you have pointed out ways
in the past that formulas can solves problems without going to VBA.

I will play with this and see how it works.

Thanks for taking the time to respond.

-tom