| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| check for value between 101 & 110 same value can't be repeated in | Excel Discussion (Misc queries) | |||
| Find repeated text in a text document in Excel | Excel Worksheet Functions | |||
| check for repeated data | Excel Discussion (Misc queries) | |||
| how do not allow a number to be repeated on the same column? | Excel Discussion (Misc queries) | |||
| Printing text in a repeated cell/row that is longer than repeated | Excel Discussion (Misc queries) | |||
Hybrid Mode
