Hi all - this spreadsheet is for tracking volunteers at a wildlife center. I need a formula that returns the first date that a volunteer showed up this year. Each cell from BN7 down and right contains the number of hours that each vol worked on each day. So basically, for each vol, I need a formula that returns the date in row 5 that corresponds with the first non-blank cell for that vol past BN. Dylan should return 1/3, Sarah and Irfan should return a blank or an error or whatever, Casey should return 1/7, etc.
I think it should involve ARRAYFORMULA and maybe SORT but past that I'm pretty stumped. Any help would be much appreciated - thanks!
I think it should involve ARRAYFORMULA and maybe SORT but past that I'm pretty stumped. Any help would be much appreciated - thanks!