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. |
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. |
All times are GMT +1. The time now is 08:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com