Hi all first post so i hope i am not posting something very common. i have been looking through the net but was unable to find something like this
basically i have a set like this
----A----------B-------C
INTEL-----2000
INTEL-----4000
BP-------10000
INTEL-----8000
BP-------30000
GOOGLE --2000
INTEL---- 4000
Each cell a is a stock with b being the cumulative units accumulated. I am looking for a formula that returns to me the last cell B if A is INTEL for example and i will input this formula into cell c.
this is to find the previous no.
i was able to do this with a google spreadsheet formula as follows
INDEX(arrayformula(filter($B1:$B$2,$A1:$A$2<>"",row($A1:$A$2)=max(if($A1:$A$2="INTEL",row($A1:$A$2),0)))) ;1)
but i dunno how to do it with excel. hope i can find some understanding here.
Bookmarks