Hey there!
So, sorry in advance because I’m definitely no Excel wizard, so please don't roast me if I describe this totally wrong... basically, I've got this spreadsheet where Column A is the date, Column B is the full name, and Column C is the location... what I'm really dying to do is make it so that in Column B—where all those names are—they aren't just sitting there staring at me, but instead, when I click the filter, I can just pick a specific name from a list... and I want to do the exact same thing for the locations!
I honestly have no clue how to put this in "tech speak," so I'm really hoping you guys get what I'm aiming for...
P.S. Just to be super clear, I'm not talking about that basic filtering where you just click a header and pick a value... like, I already know how to hit the filter on cells B1 through B10 and just check a box... that's not what I mean!
So, sorry in advance because I’m definitely no Excel wizard, so please don't roast me if I describe this totally wrong... basically, I've got this spreadsheet where Column A is the date, Column B is the full name, and Column C is the location... what I'm really dying to do is make it so that in Column B—where all those names are—they aren't just sitting there staring at me, but instead, when I click the filter, I can just pick a specific name from a list... and I want to do the exact same thing for the locations!
I honestly have no clue how to put this in "tech speak," so I'm really hoping you guys get what I'm aiming for...
P.S. Just to be super clear, I'm not talking about that basic filtering where you just click a header and pick a value... like, I already know how to hit the filter on cells B1 through B10 and just check a box... that's not what I mean!