Drop down list in Excel - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HotUKDeals, you accept our cookie and privacy policy.
Get the HotUKDeals app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Drop down list in Excel

£0.00 @
How do I create a drop down list in Excel, such that if I have a column for gender, I can click on title of the column gender, select Male from the drop down list, and all the entries for which I have… Read More
paperclip Avatar
7y, 6m agoPosted 7 years, 6 months ago
How do I create a drop down list in Excel, such that if I have a column for gender, I can click on title of the column gender, select Male from the drop down list, and all the entries for which I have written "male" are shown, and all the "females" are hidden

Hope that made sense....

Many Thanks!!!
paperclip Avatar
7y, 6m agoPosted 7 years, 6 months ago
Options

All Comments

(11) Jump to unreadPost a comment
Comments/page:
#1
Are you by any chance doing a Sociology degree and currently doing Data Analysis :-p
#2
.........Or doing your AS Level IT homework? :p

But to actually answer your question.. maybe when the drop down is selected, get it to paste in the formula sheet section, using that get an IF function to either select the male or female list.. does that make sense?

so.. male/female dropdown box ---> Paste word (e.g. H3 box) ---> Use 'IF H3, male then show male list.. else show female list...'

Will that work?
#3
or doing a survey for male and females?
#4
Also, if you really want the answer, you need to make a Pivot table. Then you can click on the options for that table and deselect females so only males are shown.
1 Like #5
Just select the heading 'Gender' and choose Data -> Filter -> Autofilter

It'll make it a drop-down menu and you can choose from your options.
#6
baffledsalmon
Are you by any chance doing a Sociology degree and currently doing Data Analysis :-p

lol no, not quite


Inquisitor
.........Or doing your AS Level IT homework? :p

But to actually answer your question.. maybe when the drop down is selected, get it to paste in the formula sheet section, using that get an IF function to either select the male or female list.. does that make sense?

so.. male/female dropdown box ---> Paste word (e.g. H3 box) ---> Use 'IF H3, male then show male list.. else show female list...'

Will that work?

hmmmm interesting way of doing it but I need to do it for several fields, so probably not the fastest way to do it


hodsey77
Just select the heading 'Gender' and choose Data -> Filter -> Autofilter

It'll make it a drop-down menu and you can choose from your options.

that's what I was after, I've seen it done before but never knew how. thanks!!!
#7
Again, I'll repeat, you need to make a pivot table. Find a "how to" guide on the internet, I'm sure there's one lying around. Quite complicated to start with but once you get used to it it's fine, especially as you've got very few fields... I did mine with 1750 :-p Then you can manipulate the data very easily. Depends what you're doing, if it's just A level stuff just do as above.
#8
baffledsalmon
Again, I'll repeat, you need to make a pivot table. Find a "how to" guide on the internet, I'm sure there's one lying around. Quite complicated to start with but once you get used to it it's fine, especially as you've got very few fields... I did mine with 1750 :-p Then you can manipulate the data very easily. Depends what you're doing, if it's just A level stuff just do as above.


"need to" is a little strong.. theres more than one say to skin a cat :thumbsup:. Its kinda like me saying its not efficient to use Excel all together with this because Access is much easier for this type of work.................... :-D Im suprised you didnt you Access instead of Excel...
#9
hodsey77 is correct. the other answers are just way over the top for such a simple filter.
#10
paperclip

that's what I was after, I've seen it done before but never knew how. thanks!!!


No probs :) Glad to have helped :thumbsup:
#11
hodsey77
Just select the heading 'Gender' and choose Data -> Filter -> Autofilter

It'll make it a drop-down menu and you can choose from your options.


+1 spot on, simple and straight to the point!

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!