Formula: If data in column B = 0, delete the row that data is in

Hello,

I have a data set looks like below (pls see the first table). is it possible to write something using formula and get me to the result ( pls see the second table). Thank you!

Name	item A	item_b	ITEM C
ABC_123	0	999	0
DEF_456	0	0	666
GHI_789	888	777	0

Result

GHI_789

888

777

Datasets

Custom Tools

Accepted answers

All comments

atcodedog05

Hi @Emma_c_857

is first 2 rows deleted because they have 2 values 0's whats the logic🤔

atcodedog05

Hi @Emma_c_857

Here is how you can do it.

Workflow:

Hope this meets your requirement.

Hope this helps : )

filter rows.yxmd

mceleavey

Hi @Emma_c_857 ,

Like @atcodedog05 I'm not sure of the logic, but just assuming you want to remove records where the second column is zero then you can do the following:

A simple filter tool removing those records gives the following:

I've attached the workflow. If this is not the required logic can you let us know?

Hope this helps,

mceleavey solution.yxmd

Emma_c_857

Hello,

yes, that was the correct logic. Thank you!

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703