Excel help - Search related

[Leopardos]

Hello,

I have 400 Rows of numbers from A to F ( Each row has 6 numbers )
The numbers are 1-37..

How could i find 12 numbers which will match as most as possible in each row for every row?

Its like lottery results... i want to check which 12 numbers will get me alot of profit in each row , consedring each Row= Lottery result...


I calculated 12 numbers which appears more than the other ..
But i didnt get good results , because the numbers was per Page, not rows..

Is there any one could help me?

Its complicated i know,
Sorry for my bad english, i hope you got my point

Thanks

 

[Charles Kozierok]

How could i find 12 numbers which will match as most as possible in each row for every row?

Can you explain more what you mean here, preferably with an example? What is it you are matching against what?

 

[Leopardos]

Can you explain more what you mean here, preferably with an example? What is it you are matching against what?

Lets assume i have this list:

2 12 20 22 24 32

12 13 16 18 35 37

11 19 22 23 25 36

2 6 12 16 21 26

3 5 10 11 12 21

i want to pick 12 numbers which will match as much as possible in each row for the whole list...
like Number 21, and 12...
They appeared in a Row twice ..

Its simple , just think of it as i want to win the lottery, i want to match the numbers in each row to win the prize,
i want to figure the numbers which appeared in a row in most of the lines..

Got it ?

 

[Charles Kozierok]

Use the "COUNTIF" function.

For example, if the data is in A1 through F400, then go to say, column H and enter this formula in the first 37 rows.

=COUNTIF($A$1:$F$400,"="&TEXT(ROW(),"0"))

 

[Leopardos]

Use the "COUNTIF" function.

For example, if the data is in A1 through F400, then go to say, column H and enter this formula in the first 37 rows.

=COUNTIF($A$1:$F$400,"="&TEXT(ROW(),"0"))

Thanks for your time and help,

Im noob with excel , i tried it and it gave me random numbers , what is this numbers exactly? and why to enter it in the first 37 rows only ?


Thanks

 

[Charles Kozierok]

You said the numbers range from 1 to 37. Those formulas will tell you how many "1"s are in the data in row #1, how many "2"s are in the data in row #2. Etc.

 

[Leopardos]

Aaaa got it , its will calucate how many times 1, or any other number appeared in the lines ..

for example:

How many 1 , 5 and 6 appeared in the same row in all lines
and if they appeared more than 1 , 5 , 7 or 1 , 5 , 8 etc....


Like finding which 12 numbers will appear the most in a each row more than others...


Thanks again

 

[Charles Kozierok]

Sorry, not following you. Might be a language issue. Maybe you can post in your native tongue and someone here can translate?

 

[Leopardos]

Ok , never mind , i will try to figure it out ...

its very complicated i will search google hoping for results ..


Cheers for trying to help