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

[Emma_c_857]

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

0

[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 : )

[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,

M.

[Emma_c_857]

Hello, 

yes, that was the correct logic. Thank you!

[Emma_c_857]

Thank you!

[atcodedog05]

Happy to help : ) @Emma_c_857 

If the response helps please don't forget to mark it as solution.

Cheers and have a nice day!