Trying to create a trading journal for my stock portfolio but cannot find anyway to make it work. Column H is my problem. What i hope to accomplish is as buy and sell orders occur the formula will return accurate previous units. thank you in advance for anyone that can assist with creating this formula.
The formula here does what i need in google sheet but have spent days attempting to translate it to excel with no luck. Hoping someone familiar will see easy solution that I'm missing.
Formula in cell H2(works in sheets but not excel) =IFERROR(IF(ROW()<>2,INDEX(FILTER($I2:$I$2,$C2:$C$2<>"",ROW($C2:$C$2)=MAX(IF($C2:$C$2=C3,ROW($C2:$C$2),0))),1),0),0)
God bless,
Jeff
Bookmarks