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

How do I check if a text value is repeated in a column (Excel)?
 

See

http://cpearson.com/excel/duplicat.htm

In article ,
"Oscar" wrote:

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