I need a function that will extract ONLY the independent directors' "time between appointment and offering"
(please see workbook)
I made an additional column underneath to show you how it's meant to look like (I got their numbers manually)
Need it to be automatic. I cannot do it manually as there are over 1000 rows to do.
Maybe Vlookup? I dont know how to do it though.
Bookmarks