Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Triple occurence formula
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |