Max. & Min. values from the set of alternate positive and negative numbers.

Hello Friends

Please refer the attached 2010 Excel file : <Angle in Excel.xlsx>.

I want to calculate the maximum and minium numbers (For 2 columns) from
the set of alternate positive and negative numbers.

The values are to be plotted in yellow cells.

thanks in advance

thilag

Hello XOR LX

thanks for your feedback.

1) In case of any zeros then we can make it as positve side.
2) Query : Can we make the formula if the continous postive or negative values are exceeding the given number (Here say in Cell I1, value is 5) then the Maximum and Minimum values should be printed otherwise it should switch for the next postive / negative value (i.e., if a continous postive count is 4 then it should omit the plotting for positive value (for that set contains 4 positive values) then it should switch for next negative values (if is contain more than 5 values ok, then it should plot the max. & min values for negative set otherwise again it should check for the next positive set like that).

thanks again

thilag

Hello XOR LX

if you uploaded the new file means very helpful for me, Otherwise i will populate a new updated file with the help of your formulas.

thanks

thilag

Sorry

I misunderstood, now i uploaded the new attachment with new conditions.

thanks

thilag

Hello XOR LX

Sorry, i totally missed 1 major point regarding zero. You earlier notified to me but i missed it.

Now i attached the new excel file <Angle in Excel3.xlsx>.

I listed cleraly the Cell value I1 = 5 and the new conditions about zero.

New Conditions :
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 yellow cells
4) If Zeros `0' Available then it should be taken as Positive value if it is available in the Positive set of light green 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

thilag

Hello

Sorry I missed while typing, for 8 also `Here zero is taken as positive value' comment applicable.

thanks

thilag

The Reason is Light Yellow set values A2:C17 contains positive values in Column C i.e, C2:C17.

Rule 3 "3) If Zeros `0' Available then it should be taken as Negative value if it is available in the Negative set of light yellow cells"
Rule 4 "4) If Zeros `0' Available then it should be taken as Positive value if it is available in the Positive set of light green cells"

As per the note 3) & 4) it should be positive only.

thanks

thilag

Sorry

I changed the condition 3) & 4) color and uploaded the new file.

now you can go ahead.

thanks

thilag