One play ..
With the posted source numbers in A1:A3
(numbers are assumed text numbers, may have leading zeros)
Put in say, B1:
=IF(SUMPRODUCT(--(ISNUMBER(SEARCH(COLUMNS($A$1:A1)-1,$A1:$A3))))=3,COLUMNS($
A$1:A1)-1,"")
Copy B1 across 10 cols to K1
B1:K1 will return the results
Or, vertically,
Put in say, A5:
=IF(SUMPRODUCT(--(ISNUMBER(SEARCH(ROWS($A$1:A1)-1,$A$1:$A$3))))=3,ROWS($A$1:
A1)-1,"")
Copy A5 down 10 rows to A14
A5:A14 will return the results
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"toyota58" wrote in message
ups.com...
Anyone knows how to make a triple occurence formula ?
Example:
Cell A1 = 2356789
Cell A2 = 01345
Cell A3 = 012345
Here we find that 3 and 5 have triple occurence.
Thank You.