16,553 views
If you have a lot of data, for example, from sales and sales representatives, and you want to search for a specific representative, a specific product, specific quantities, a specific price, an address, a country or a region, how do you do that? In this video, I will explain all of this, how to build a search box that searches in more than one column for a name or a specific product using a word or part of a word or even more than one word. Also, how to make Excel color the cells that contain the text you are searching for with a color you choose. All that in this video and these are the links to the videos that were mentioned in this video: Amazing uses of Filter: • Amazing uses of Filter, you will not expect them Advance Filter: • You have a lot of data and many filters that you must... What is the magic of (#) in equations: • When should you use (Hash - #) in equations... Practical examples of (#) in equations: • Practical examples of hash (#) in equations... Search box to mark specific cells: • Professional search box to shade cells - Sea... #Excel #Excel #exceltips #function #search #searchbox #Automatic_numbering