Google Sheets Numeric Search

Заказчик: AI | Опубликовано: 04.02.2026
Бюджет: 30 $

I need a simple, reliable search form built directly inside Google Sheets that lets me type any number (or partial number) and have the matching rows appear instantly. The sheet will hold only numeric data, so the form, formulas, or Apps Script you choose should be optimized for fast numeric lookup and filtered display. All logic and UI must live within Google Sheets—no external apps—because I’ll be sharing the file with teammates who already use it daily. I’d like the final version to include clear labels, an input field for the search value, and automatic clearing/reset so a new search is always clean. If an Apps Script is the best route, please comment your code for future tweaks; if advanced formulas alone can handle it, that works too. Speed matters: I’d like to test and sign off on the working sheet as soon as possible.