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
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
Need more information - what do you mean by a pattern, show some expected results, etc.
Glenn
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:
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.![]()
Please Login or Register to view this content.
Thanks for your help i will give it a go.
H
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks