Forum menu
[Closed] ** Sounds the STW Excel Experts klaxon **
Dynamic Excel Filter Search Box.
I've managed to do one of these on one sheet using raw data from another.
How do I create a second box on the same sheet please? I'd like to have a few of these boxes so users can type/select above the column they know some detail for eg part of a document name or the category its in.
I've repeated steps I took for the first box using new helper columns. I'm at the stage where I typed and copied the final formula across all cells in the user sheet. I don't know how to do this last bit as surely I'd overwrite the existing formula?
Formula in question is:
IFERROR(INDEX(Sheet1!$A$12:Sheet1!$N$323,Sheet1!$R12,COLUMNS($A$6:A6)),"")
Thanks
Should I just have one box and adjust the formula so folk can type into it to search under document name or category or doc number etc?
Off topic, but what other STW klaxons are there?
There's a mortgage klaxon, a savings klaxon, a business class klaxon just to name a few.
Dumb question - but couldn't you use slicers instead?
Dumb question – but couldn’t you use slicers instead?
They don't make the right noise - it has to be a klaxon