Drop-down list with quick search (with filter) in Excel
Today we'll learn how to create quick search lists. Our goal is to create a search so that when you enter a text fragment into a cell, Excel will display only the rows that contain that text.
Download the lesson file here: https://disk.yandex.ru/i/bFh6httQR2ML5w
Follow me on Telegram: https://t.me/excelroad
Timecodes
00:00 How a quick search drop-down list works
04:00 Writing the first formula
07:42 Writing the second formula
10:20 How the OFFSET function works
12:05 Writing the third formula
15:01 Connecting a drop-down list to a data table
Follow me on Telegram: https://t.me/excelroad
#Excelonline #ExcelForBeginners #ExcelLessons