Excel dummy data check

[aeolus187]

Hi Alteryx Engineer,

I have one strict-formatted excel for client, there is some range for client data suppose A1: F20 ,  I need to check outside this range, if there is any white space and i need to identify it by knowing its location， for example is there is space at cell A35 and B50 I need to return  "A35/B50 white space" at some column. 

[sparksun]

Here is my solution for your reference,I use Null value checking in the sample,you may change it to whatever you want:

[aeolus187 · Accepted solution]

@sparksun 

Hi Sparksun, I want to check if there is white space outside the data range, your solution is to check inside the data range, for below i wanna get A44 as my result

[JarekSkudrzyk]

@aeolus187 

actually @sparksun 's solution checks outside the range - in the example the range ends at 3, not 20 as you described.

Just change the value 3 to 20 in this filter:

[sparksun]

My solution is ony a sample for you to understand how to build up the logic.

In my sample data,A1:C3 is the range for client data,I use filter tool to get only the data out of the range and check only Null data out of A1:C3.Based on this logic, you can make any change to match your own actual data.

[aeolus187]

@sparksun 

ok  I understand now thanks for the explaination

[aeolus187]

@sparksun 

by the way, can we have better way to define the data range instead of hard-coded below?