Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to find the duplicate text from a column or from a row?
|
#2
|
|||
|
|||
In a helper column
=IF(COUNTIF($A$1:A1,A1)1,"Dup","") and copy down -- HTH RP (remove nothere from the email address if mailing direct) "Yohan" wrote in message ... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
How can you find duplicate numbers in a column? | Excel Worksheet Functions | |||
Putting text in a column based on variable text from another colum | Excel Discussion (Misc queries) |