How to check cells having numeric values in excel

Hi, NoNumber.zip (2.4 KB)
I tried this process but not getting the expected output.
Input


If “Address” Column does not contain numeric values then the “Status” should be “B” otherwise Blank

Output I need


Tried many processes but not getting Result correctly…It would be of great help if anyone suggests me some idea for this.
Thanks & Regards.

@Kavyasri

You can use Read Range and Foreach row and Check as below

False if no number

For reference of Read Range and Foreach row and placing the value in datatable, check below

Like and vote if this helps you

Mark as solution if this helps

Thanks

4 Likes

Hi @ksrinu070184 , Thanks for the reply…You are doing it by taking seperate statements…But I want to do taking everything at once using simple conditions…Can you suggest me any idea…NoNumber.zip (2.4 KB)
I used read range and for each loop also,once see this workflow and please tell me if anything is wrong.

@Kavyasri

I have given you the sample, can you provide your sample excel file

I will make some changes to your flow

Thanks

1 Like

@Kavyasri

Check attached

NoNumber.zip (2.6 KB)

Test with your excel file and let me know if you have any issues

Thanks

1 Like

Data.xlsx (9.3 KB)
Thanks @ksrinu070184 ,This is the one

okay…thank you

@Kavyasri

Below is the result

image

Mark as solution if this helps

Thanks

1 Like

Yeah @ksrinu070184,Its working…Thank you so much…Can you please explain me this as I am not aware of this function

1 Like

@Kavyasri

That’s a regex function to identify the number

ISMatches will return the true or False

Thanks

2 Likes

Ok…Got it.Thank you @ksrinu070184

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.