Excel finding patterns across data range

Hi

I have a sheet with 6 rows of data per entry and a column indicating if the data is positive or negative, ((1 for positive) can excel analyse the numbers across the rows to find a pattern if indicated as positive?


Thanks for any help offered

And more specifically .. how do you determine a row is either positive or negative ? There doesn't seem to be a correlation with the numbers ???

I am trying to see what numbers from what columns form a pattern when i deem it a positive result by entering 1 into a row in column h

For example if the result is positive does the number 3 appear often in column b or the number 2 in column c etc

Paste this into a Routine Module, activate from a Command Button on Sheet 1:

Please Login or Register  to view this content.

Move your Positve/Negative column to Col M. This will prevent the code from considering the 1's and 0's in that column as part of the pattern.

Thanks for your help i will give it a go.

H