View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
smandula smandula is offline
external usenet poster
 
Posts: 116
Default Duplicate Digits

Could there be a solution, without conditional formatting,
of being able to

Count duplicate or triplicate etc. digits within a single cell

For example
Data Count
A1 B1
5555 4
1112 3
1122 2
1234 0
1101 3


I have tried this formula with some success

=IF(MOD(A1,1111)=0,"4",IF(MOD(A1,111)=0,"3",IF(MOD (A1,11)=0,"2",))
for one Cell A1

Thanks