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.
* 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)
* 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.
1) if the total positive or negative value count is greater than given value in cell I1 (Here 5 is plotted) then the values are to be plotted in yellow cells.
2) if the total positive or negative value count is less than or equal to given value in cell I1 (Here 5 is plotted) then the values are to be omitted / skipped in yellow cells.
Example : In Rows 18 to 22 cells A18 to C22 the total negative set count is 5 (Including zero), which not mets the condition so omited.
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.
The values are to be plotted in yellow cells.
thanks in advance
thilag
Bookmarks