Clay Icon
Join the Community
02 Support

Automatically Deleting Rows Based on Conditions in Excel

Avatar of Bruce W.Bruce W.
·
·

Hey, is there a way to automatically delete a row after a condition is met?

5 comments

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Hey there Bruce thanks for reaching out

  • Avatar of Bruce W.
    Bruce W.
    ·
    ·

    I have one table that will get to way over 50k rows, but once the enrichment is done I am sending it to a different location

  • Avatar of Bruce W.
    Bruce W.
    ·
    ·

    So I need to be able to automatically delete that row with code once a formula is met

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    Automatically deleting rows isn't possible, but a workaround would be to create a view for all rows that do not meet the condition and then selecting all and deleting all at once.

  • Avatar of Clay Team
    Clay Team
    APP
    ·
    ·

    You can do so by creating a filter and than making a view for that filter.