Triple occurence formula

T

toyota58

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.
 
M

Max

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
 
Top