Thread: Detect double digit
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
David F Cox David F Cox is offline
external usenet poster
  
Posts: 37
Default Detect double digit
=MOD(RIGHT(A1,2), 11) = 0

"ShamsulZ" wrote in message
...
I'm looking for a formula that enable me to detect any no. of last 2 digit
that is the same for e.g 1233, abcd2345677, 90566 etc. Thanks for your
help



Reply With QuoteReply With Quote