I want to return value 1 in Column E if INDEP_DIREC (column D) has value/no. of directors >= 3 for year 1995-2003 for firms in column A (Tickers). AND return the value 0 in if value/no. of directors >= 3 at any year between 1999-2003 in column F.
I tried doing this manually but due to long dataset it's quite difficult to manage this manually. Not quite sure which formula to go around this.
Any help would be appreciated.
Bookmarks