Formula: First non blank after last blank cell in Range
Each row has both blank and no-blank cells, for all you know it could be delivery information where days with no deliveries are blank and delivery days are non-blank. Our task is to return the first delivery after the last non-delivery day in the range
Link to workbook:
https://docs.google.com/spreadsheets/...
00:00 Introduction and background
01:47 Using XLOOKUP function
02:40 Address function to confirm XLOOKUP
04:10 Circular reference error
05:16 Fixing the circular reference error
06:40 Method 2 -Using XMATCH
08:30 Making the formula spill
09:56 Concluding thoughts