hey. can someone help me with a macro something , I have a file with more varinte of those variants want to know who were often together.



I have some formulas in the file , but I am looking to take a lot of time manually , CF- CM cells are options that I 'm looking for them , the NC is a formula that shows how many times it is found , as well as the CD .

how can I seek them , a macro something to look each numbers of cells CF- CM and look in her right whenever found

Attached Files

mod.xlsx (10.4 KB, 8 views)

The only formulas I see is on in CN1 and then some crazy ones in column CD.

Basically, it appears these formulas are counting how many times each number in CF to CM are occurring in A to CB and then multiplying these counts together. The final result is going to equal zero anytime any of the numbers in CF to CM are not found in A to CB. The result is one if and only if all the numbers are found.

The formula in CN1 then counts the number of instances where all conditions are met. Is this basically what you are trying to do?

If so, I see that, with the exception of the rows with no data in CF to CM, all data in CF to CL are identical with the exception of row 3. Only CM has different data in each row. Please clarify your intent here.

Perhaps these links would be good to know about ?

http://www.excelguru.ca/forums/showt...-the-data-base
http://www.vbaexpress.com/forum/show...-the-data-base
http://www.excelforum.com/excel-prog...data-base.html
http://chandoo.org/forum/threads/fin...ta-base.24494/
http://www.mrexcel.com/forum/excel-q...data-base.html

row 1 in cf- cm cells I'm looking for these numbers 1,4,9,11,12,32,35,39 ,
when it finds ,in cell cn showing 1 .
I 'm looking for and more ,cells that are cf-cm row 2,3,4,5,6,7,,,,,,,
and indicate cn cell lines 2,3,4,5,6,7 ,,,, whenever found.
there are many variations, and to seek them manually move them to cf- cm each one takes time

Hi

heavy cross poster - Thread closed

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post