Thread: How do I check if a text value is repeated in a column (Excel)?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
oscar oscar is offline
external usenet poster
  
Posts: 55
Default How do I check if a text value is repeated in a column (Excel)?
I have a spreadsheet and have about 1000 rows x 20 columns of data. One of
those columns is a text value and I want to check and see if I don't repeat
any text in another cell. For instance if I type apple in A1 and by type it
again in A103, I would like a warning letting me know that apple was already
typed, some condition or something.

Thank you and I hope somebody can help. Oscar
Reply With QuoteReply With Quote