Hello Friends
Please refer the attached 2010 Excel file : <Angle in Excel5.xlsx>.
I want to calculate the maximum and minium numbers (For 2 columns) from
the set of alternate positive and negative numbers.
Old thread link for reference :
http://www.excelforum.com/excel-form...e-numbers.html
Requirements :
1) If a set of Positive values in `C' column then the maximum and minimum values to be plotted in Cells G (From Column A) & Cells H (From Column B)
2) If a set of Negative values in `C' column then the maximum and minimum values to be plotted in Cells G (From Column A) & Cells H (From Column B)
Note : The positive and negative values will change alternatively so that the formulas should be taken care of this.
3) If Zeros `0' Available then it should be taken as Negative value if it is available in the Negative set of light green cells
4) If Zeros `0' Available then it should be taken as Positive value if it is available in the Positive set of light Yellow cells
5) If Zeros `0' occurs in between inbetween Negative and Positive Set then take it as Positive Set.
6) If Zeros `0' occurs in between inbetween Positive and Negative Set then take it as Negative Set.
7) Note : If the Zero `0' in between Negative and Positive Set (Point 5) & Positive and Negative Set (Point 6) then you can the zero as Positive or Negative value (Vice versa for Point 5 & 6) Since it is not a big deal. But the Points 1) to 4) are obvious requirements.
Thanks to XOR Lx for help against old post.
Just reference sheet is only for reference.
The values are to be plotted in yellow cells.
thanks in advance
thilag
Bookmarks