Previous value row number - Stock Spreadsheet

[leeboy168]

Hi guys,

I'm not an expert, but I'm currently trying to replicate a stock portfolio spreadsheet that was completed in Google Sheets (because I like excel better) and can't for the life of me figure out how to find the previous row number of a certain value. In the example below, the spreadsheet manages to find the previous row number of "Macquarie International Infrastructure Fund" - are you guys able to provide me with an excel formula that does this?

The google spreadsheet formula is: =ARRAYFORMULA(max(if($C$1:$C6=C7,row($C$1:$C6))))

 

[LockeGarmin]

Array formulas are created in Excel by pressing Ctrl+Shift+Enter at the same time. So you'll want to erase the ArrayFormula function from the google sheet (see below) and press Ctrl+Shift+Enter for it to work properly.

=max(if($C$1:$C6=C7,row($C$1:$C6)))

 

[leeboy168]

Array formulas are created in Excel by pressing Ctrl+Shift+Enter at the same time. So you'll want to erase the ArrayFormula function from the google sheet (see below) and press Ctrl+Shift+Enter for it to work properly.

=max(if($C$1:$C6=C7,row($C$1:$C6)))

Doh! Thanks Locke!!