Excel dummy data check

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.

Help

Accepted answers

aeolus187

@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

All comments

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.yxmd

aeolus187

@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?

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703