VBA/Macro Excel Formula Autofilter 50 Asterix Criteria
This formula is suitable for those of you who are involved with Big Data to facilitate their work also for you Data Entry specialist.
How does this formula work?
This formula can delete any rows that contain criteria that we define.
For example, you have a list of 2000 fruit names, but there are many names that have text fish, birds, and snakes.
You want to delete every rows that contains the words fish, bird, and snake so that only the names of the fruit are left.
If there are only 10 or 100 data, it might be easy to do it manually. What if there are 2000 data, 10,000 data, or 100,000 data? it's frustrating
For more detail about how this formula work, just watch the video above !