Hi All!
Banging my head against a wall here and appreciate the help!
I'm effectively looking to create a flagging system to account for false-positives (desired output from the formula represented in column 5).
Effectively i want to look through column 2 (values) and return a 0 if within a column a 0 value appears before the minimum value of that row.
i.e for row/index 3 to 6: all of these have values greater than 0, however they are lower than their respective minimum value. Then row 7 equals 0. So i want to return in column 5 a flag = 0 against rows 3 to 6.
this is different for rows/index 14 to 22: where all these values are greater than 0 and less than their respective minimum value, however then row 23 has a value greater than its minimum value. i then want for 14 to 22 to return a flag =1
col 1 col 2 col 3 col 4 col 5
index Values Minimum Value Flag 1: is value > 0 flag 2: does a zero appear before corresponding minimum value
1 0 20 0 0
2 0 20 0 0
3 4 20 1 0
4 11 20 1 0
5 17 20 1 0
6 19 20 1 0
7 0 20 0 0
8 0 20 0 0
9 0 20 0 0
10 0 30 0 0
11 0 30 0 0
12 0 30 0 0
13 0 30 0 0
14 1 30 1 1
15 4 30 1 1
16 6 30 1 1
17 7 30 1 1
18 8 30 1 1
19 14 30 1 1
20 19 30 1 1
21 25 30 1 1
22 28 30 1 1
23 34 30 1 0
24 0 30 1 0
Hope this makes sense and someone is able to help
Bookmarks