Hi,
I'm trying to return the first and last instance of a blank cell within a date range without doing an array formula (the master spreadsheet is very large, so trying to make it as "quick" as possible).
R1: Start date in range to be searched (will be manually updated)
R2: End date in range to be searched (will be manually updated)
Column O: List first instance of blank cell within date range identified in R1 (hoping to automate)
Column P: List last instance of blank cell within date range identified in R2 (hoping to automate)
I've manually entered the values in columns O&P in red text, so you can see what values I'm hoping to return. Any help would be greatly appreciated!
Thank you!
Bookmarks