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 easy way you can call up employee details from a large data set using a search box.
To learn how to design the search box, follow the step-by-step guide in this video training
You can download the workbook here to work along and gain a better understanding.
It is important you know that the FILTER function used in this tutorial is only available in Excel 2019 and 365 office versions.
When you download the workbook using an Excel version earlier than 2019 and office 365, the #NAME error will be displayed in cells where the FILTER function is applied.
Hey!
Did you get value from this training?
Kindly use the comment section to send your feedback as this will help serve you better.
Do well to share this value-packed training with others.
Thank you!