Quote:
Originally Posted by Joelyben
I don't understand. Never seen this in excel. There is no command.
My idea was this.
Column C =If(b2<0,1,0)
Assigning a value of one if negative, 0 if positive.
c2=d2
Then if(c2=1,c2+d2,0)
max (d:d)
Shouldn't this come up with it? Where am I going wrong?
Dude, you suck. It would have taken you 3 seconds to try what I suggested and then you would have seen it worked. Its not rocket science.
In future, i'd suggest mrexcel.com, they probably have more patience than I do.