Hello,
I'm looking to use a combination of index and match to do the following:
Cell B1 contains a row number that is editable. I have it so once the row number is entered, cell B2 returns the first value completed in the given row. Now, I just need cell B10 to return the 'week' that the first value entered shows up. Photo example below -- thanks in advance!
I'm looking to use a combination of index and match to do the following:
Cell B1 contains a row number that is editable. I have it so once the row number is entered, cell B2 returns the first value completed in the given row. Now, I just need cell B10 to return the 'week' that the first value entered shows up. Photo example below -- thanks in advance!
