Share via

How do I filter this?

Anonymous
2024-08-06T11:39:40+00:00

Hi there, I have a table that looks like this. I am not sure if it is possible to filter and delete rows as I want.

I have a list of thousands of account IDs (for the example I have put only the first 4 account IDs) and what I want to do is to find which account IDs contain in the column 'Sales Organization ID' the entry LE801BR and delete all the rows that match those account IDs that contain LE801BR. For example, the first 2 account IDs 8232334, 8953132 contain a LE801BR in one row Sales Organization, so I want to delete ALL rows of that account ID and keep only the account IDs that do not contain in Sales Organization the LE801BR, in this case, the last two account IDs of the table ID8953132 and 7689995.

I don't know if I have explained myself well, I hope so and thanks in advance for the help!

PD: In the example would be as easy as manually check which accounts ID contains the LE801BR and manually delete all the rows with that account ID, the problem is that I have a document with over 1000 Accounts ID and need to delete all of them that contains LE801BR in Sales Organization column.

Account ID Sales Organization Distribution Channel
8232334 LE008BR Direct sales
8232334 LE014BR Direct sales
8232334 LE018BR Direct sales
8232334 LE029BR Direct sales
8232334 LE034BR Direct sales
8232334 LE800BR Direct sales
8232334 LE801BR Direct sales
8953132 LE008BR Direct sales
8953132 LE014BR Direct sales
8953132 LE018BR Direct sales
8953132 LE034BR Direct sales
8953132 LE800BR Direct sales
8953132 LE801BR Direct sales
8953150 LE008BR Direct sales
8953150 LE014BR Direct sales
8953150 LE018BR Direct sales
8953150 LE030BR Direct sales
8953150 LE034BR Direct sales
8953150 LE800BR Direct sales
7689995 LE008BR Direct sales
7689995 LE014BR Direct sales
7689995 LE018BR Direct sales
7689995 LE029BR Direct sales
7689995 LE034BR Direct sales
7689995 LE800BR Direct sales
7689995 LE008BR Direct sales
Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

3 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. HansV 462.6K Reputation points
    2024-08-06T12:01:01+00:00

    I'd add a column to the table with formula

    =COUNTIFS([Account ID], [@[Account ID]], [[Sales Organization ]], "LE801BR")>0

    You can then filter this column on TRUE and delete the filtered rows.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more

  3. Anonymous
    2024-08-06T12:10:52+00:00

    That worked! Thanks a million for your help and have a nice day!

    Was this answer helpful?

    0 comments