Paul,
When I did the second formula, it only showed the word "OK" in the column.
Thank you!

"PCLIVE" wrote:

One possible way:

Use a helper column.
=LEFT(A1,1)+MID(A1,2,1)+RIGHT(A1,1)

Then in another column use:
=IF(AND(COUNTIF(B$1:B$6,B1)1,COUNTIF(A$1:A$6,A1)= 1),"Possibly
Transposed","OK")

HTH,
Paul


"brokerdee" wrote in message
...
I have a row with numbers like this:
123
456
231
794
344
645
How can I find the numbers that are repeated though their digits are
transposed?