jeudi 20 février 2020

Filter formula for multiple cell references

How can I make it so the formula on E2 reads values entered in any of the search cells and displays it as results, considering I have a button to clear all search boxes and users are instructed to only search one box at a time and to press the button if multiple boxes are filled?

See image

Here's my editable Spreadsheet

Much appreciated.

Aucun commentaire:

Enregistrer un commentaire