Selecting > Value Data based upon Flags (1's or 2's)

[Mike Slattery]

I have three columns. The first is detecting and flagging if the price is coming from a Resistance Turning Point (1) or a Support Turning Point (2). A blank cell indicates that the price for the day did not occur at a turning point. The result of this exercise is designed to return/display a Zig Zag chart of High/Low points at Turning Points or support and resistance. The problem is there are points in the data where multiple tops (1's) or multiple bottoms (2's) are detected. This is not a mistake, but what is transpiring in the data. I need to be able to detect when a (1) is followed by another (1) and select the data point that contains the higher price (Col DG) of the two. I need to accomplish the same function for when two (2's) are encountered. If a (1) is followed by a (2) or a (2) is followed by a (1) no action is necessary.

Grateful for any suggestions, Thanks Michael

Setup below:

The formulas in the three columns are below:
DF: =IF(CN3>CW3,1,IF(CW3>CN3,2,""))

DG: =IF(CN3>CW3,CN3,IF(CW3>CN3,CW3,#N/A))

DH: =IFERROR(IF(DG3>0,CA3),"")

Data in Columns DF, DG, DH.

DF___DG ______DH_____
#N/A
#N/A
1 15.76 01 06 14
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
2 15.1 12 24 13
#N/A
#N/A
#N/A
2 15.17 12 18 13
1 16.99 12 17 13
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
#N/A
1 17.2 12 03 13
1 17.2 12 02 13