Home

Populating a cell in ref to another cells specific contents (first/last blank cell in sequence)

%3CLINGO-SUB%20id%3D%22lingo-sub-824212%22%20slang%3D%22en-US%22%3EPopulating%20a%20cell%20in%20ref%20to%20another%20cells%20specific%20contents%20(first%2Flast%20blank%20cell%20in%20sequence)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-824212%22%20slang%3D%22en-US%22%3EHi%20all%2C%20I%20need%20some%20help%20with%20a%20formula%20that%20will%20reference%20a%20few%20cells%20to%20get%20a%20result.%20I%20need%20cell%20D2%20to%20reference%20cell%20Z2%20(which%20identifies%20the%20max%20number%20of%20consecutive%20blank%20cells%20in%20sequence)%20and%20then%20identify%20the%20first%20of%20the%20blank%20cells%2C%20and%20then%20fill%20D2%20with%20the%20date%20in%20row%201%20(attached)%20Then%2C%20secondly%2C%20I%20need%20cell%20E2%20to%20reference%20cell%20Z2%20and%20then%20identify%20the%20last%20of%20the%20blank%20cells%2C%20and%20then%20fill%20E2%20with%20the%20date%20in%20row%201%20The%20outcome%20for%20row%202%20-%20D2%20would%20fill%20with%205%2F01%2F2019%20%2F%2F%20E2%20will%20fill%20with%2016%2F01%2F2019%20Attached%20is%20a%20snap%20shot%20example%2C%20YELLOW%20cells%20are%20the%20first%20and%20last%20consecutive%20cell%20in%20sequence%20which%20I%20am%20trying%20to%20identify.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-824212%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eformula%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor
Hi all, I need some help with a formula that will reference a few cells to get a result. I need cell D2 to reference cell Z2 (which identifies the max number of consecutive blank cells in sequence) and then identify the first of the blank cells, and then fill D2 with the date in row 1 (attached) Then, secondly, I need cell E2 to reference cell Z2 and then identify the last of the blank cells, and then fill E2 with the date in row 1 The outcome for row 2 - D2 would fill with 5/01/2019 // E2 will fill with 16/01/2019 Attached is a snap shot example, YELLOW cells are the first and last consecutive cell in sequence which I am trying to identify.