If formula question

Copper Contributor

When using the  "IF" statement, can you tell it to delete a row?

4 Replies
The "If" statement is a function that returns data, see the help article below.

https://support.office.com/en-US/article/IF-function-69AED7C9-4E8A-4755-A9BC-AA8BBFF73BE2

Describe what you are trying to accomplish and I'm sure someone will be able to provide some guidance for you. :)

If only VBA or you may use the trick with filtering row to delete with help of IF statment, idea, for example, is here https://www.youtube.com/watch?v=btZsWvtBibs

 

I merged 2 worksheets.  I want to delete a row that has data in a particular column. 

And which technique do you use to merge?