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
kiara1992
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.
Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies