ok here it is. The first tab is what it should look like. The second is the data, i had to cut 2/3 out to make it small enough so it should be 2394 rows by 30 columns, but you can still use it to find 1L, 1R through 10L, 10R to test it). The third tab is where i need the formula to put the results.
In case it helps to visualize this is an EEG map of the brain so im looking at different frequencies from 1-30 in 44 different parts of the brain both left and right. So in this case I'm trying to find the max score, or furthest from 0 whether its positive or negative at 1hz in area 1 left of the brain. Some areas have 3 different points and some like 20 have almost 40 different points i have to compare.
again thanks so much.
Kevin
|