Hi All, I'm looking for a formula to : (Date Range is C10 : C28 and Close Price is D10 : D28)
Return the highest date where the adjacent cell doesn't equal "No Data"
Note the Date Range won't necessarily be in date order as shown in my screenshot
All help is appreciated.
Return the highest date where the adjacent cell doesn't equal "No Data"
Note the Date Range won't necessarily be in date order as shown in my screenshot
All help is appreciated.