Thank you for this - very much appreciate your video including the recent update! Been wondering why my filter only worked for 1 cell - the transpose thing is very silly.
@videomonkpvr4 ай бұрын
Can not thank you enough for this
@AlisonWalshEOM19 күн бұрын
For some reason this only worked for me when, for the step shown at 08:16, I did NOT replace C3:AM3 to C3:AM1000. It only worked when I left it at $C3:$AM3. Otherwise it kept listing the full list of dropdown items and not the filtered list. But maybe I am doing something else wrong. Either way, thank you for this!
@matttechtidbits19 күн бұрын
Huh interesting! Glad you got it to work! I was testing it and the $C3:$AM3 works and probably is the more sure-proof method! The range locks columns in and goes by rows as you pull it down. The way I showed did work as long as there wasn’t anything in that range before setting up the data validation range down to 1000. If there were different departments/ names on it before adding it seems to pull all names on it as you said! If that happened I was able to just clear the names then it worked as expected. Either way thanks for commenting and glad you got it working as well!