Hi.
I have been here for some time, and have always been able to find someone with a similar case. But not this time - so now it is my time to hope for some expert help.
I have a list of items supplied by supplier - sometimes they donīt send all and sometimes they send more - So I made an accumulate sum to see outstanding. So the value fluctuates from negative over zero to positive, and back again.
I would like to return the column title from when an item goes negative and stays negative.
Here is a picture of when I am trying to explain.
1.gif
I have in line row 48 a value of -228 in week 21 and a plus in week 22 - then it goes minus again week 23 and stays there until now. So I would like to return "Week 23" - not as I am only able to do - return the first negative (Week 21).
It can go from negative to positive a lot of times - so somehow I have to include a IF function - stating that a total (until the end) has to still be negative.
Colomn 159 that starts negative and turns positive - I have filtered out on my result page - so it is only showing if total is negative.
But how to get formula in column H to return - not the first - but the first of the last negatives. Phew - hope I explain myself good enough
I have also attached the excel file for any one willing to assist me in this.
Thanks in advance - and please help me prove to my colleagues that excel are really able to do everything. (In this case just my skills are not sufficient)
Jan LP
Bookmarks