Check similar entries within the cell

[vkgupta]

I have following data in a sheet

110 rows and 39 columns has data (data_range) following is the sample

Cell A1 345,267,897

(one cell has 3 numbers)

Cell A7 267

Cell D20 345

etc..etc..


Now I have another sheet with nos from 1 to 1000 and in 1 to 1000 rows and I need to mark how many times each no is repeated in data_range?


Pl advise..

 

[Luke M]

How about something like:

=SUMPRODUCT(--ISNUMBER(SEARCH(A1,data_range)))