Identify first non blank cell

Question

Hi ,

I am trying to extract the non blank value from the below table and also the adjacent blank cell next to it.

I have two columns. A2 has the sum of all rows . I want extract the last two cells such that it is it last non blank cells +1 from A1 and last non blank cell from A2.can this be achieved?

atcodedog05 · Answer

Hi @hegdepavithra10

Here is a workflow for the task.

1. Filtering columns where A1 is blank and A2 is non blank

2. Taking first occurrence of it.

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

First A1 blank & A2non blank row.yxmd

philipmannering · Answer

Hi @hegdepavithra10

This can most definitely be achieved.

1. Just filter A1 to Nulls/Empties.

2. Just in case there are multiple nulls, sample the first. See attached.

First blank row.yxmd