View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Elton Law[_2_] Elton Law[_2_] is offline
external usenet poster
 
Posts: 173
Default Find 2 highest point to form resistance line

Dear expert,

Have left a post for finding 2 lowest point for form a support line.
Now, would like to find 2 highest point to form a resistance line.
Data is from an array for formula.

In this case, should choose 91.27 and 87.96 to form resistance line.
Although 89.95 is higher than 87.96, line is forward plotting.

Is it possible?
If the highest in last row, can show "No line".
Thanks

52.35 26-Jan-10
59.87 18-Feb-10
89.95 26-Feb-10
85.41 05-Mar-10
91.27 10-Mar-10
87.96 23-Mar-10
36.69 29-Mar-10