TdC said:erk! other formulae don't react to the pull-down's choices
TdC said:nah JB, iirc you can only use one autofilter at a time (don't call me on this, because excel guru I am not hehe)
Tears: yeah mate, I see what you mean. I could make a "console" thingy in the spreadsheet with the pulldown menus, and then use the menus to generate the text and layout I'm after in a different part of the sheet.
I don't have office at home, or I'd test it. Tomorrow at workies will be the thing then.
Thanks for the efforts guys!
TdC said:another question:
I'm using a function to find certain text:
=IF((FIND.ALL("FEE";D7;1));"foo";"bar")
if cell D7 is "FEE" then the output of the function is "foo", but if D7 isn't "FEE" but something else the function doesn't return "bar" but "#VALUE!"
what am I doing wrong?
TdC said:what am I doing wrong?