Excel for Professionals

filter exact and partial match in Excel

HOW TO DESIGN A SEARCH BOX THAT FILTERS PARTIAL AND EXACT MATCH

/ Excel for Professionals, Excel Formulas

Follow the steps in this video tutorial to learn how you can design a search box that filters partial and exact match in Excel. Understanding how to design this will help you extract specific data from an extensive database to a different section on the same worksheet. You can watch the video tutorial here. Ensure …

HOW TO DESIGN A SEARCH BOX THAT FILTERS PARTIAL AND EXACT MATCH Read More »

search box that filters exact match

HOW TO DESIGN A SEARCH BOX THAT FILTER EXACT MATCH IN EXCEL

/ Excel for Professionals, Excel Formulas, Excel Tips

Imagine having a large database of employee details and you desire to search for an employee that starts with a particular First Name. You will either have to scroll through the large worksheet to get details of such employees or better still activate the Filter option in Excel. In this tutorial, I will share another …

HOW TO DESIGN A SEARCH BOX THAT FILTER EXACT MATCH IN EXCEL Read More »