| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you change single digits to recognized double digits? | Excel Worksheet Functions | |||
| VBA write macro change column with 3 number digits to 4 digits the | Excel Discussion (Misc queries) | |||
| number 12 digits to 15 digits | Excel Discussion (Misc queries) | |||
| VBA to delete Duplicate Records (1 column), before which, non-duplicate data merged into remaining row | Excel Programming | |||
| How to customize number to 10 digits including 2 digits after deci | Excel Worksheet Functions | |||
Threaded Mode
