We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
excel help needed
symy@nufc
Posts: 295 Forumite
in Techie Stuff
hi guy!
am havin trouble useing drop downs in excel!!
am not the best at it . i will try and explain av made a album list wat am trying to do is put all the songs into a drop down so i can see whats song are on the album. av used mediamonkey to create a song list to excel copyed it but it will not let me paste it to coments box???
is this me just being thick???
am havin trouble useing drop downs in excel!!
am not the best at it . i will try and explain av made a album list wat am trying to do is put all the songs into a drop down so i can see whats song are on the album. av used mediamonkey to create a song list to excel copyed it but it will not let me paste it to coments box???
is this me just being thick???
dont drink and drive:beer: :beer:
come on the toon!!
come on the toon!!
0
Comments
-
meadinkent.co.uk/xldropdown.htm
dont know if thats any use to you0 -
If you list the albums and the songs in columns A/B respectively you can use autofiltering.
You would end up with something like:-
Column A....Column B
Album 1......Song 1
Album 1......Song 2
Album 1......Song 3
Album 1......Song 4
Album 1......Song 5
Album 2......Song 1
Album 2......Song 2
Album 2......Song 3
Album 2......Song 4
Album 2......Song 5
Using autofilter in Column A, you can select the album to see what songs are on it, autofilter in Column B will allow you to select a song and show the song and the album it's on.:wall: Flagellation, necrophilia and bestiality - Am I flogging a dead horse? :wall:
Any posts are my opinion and only that. Please read at your own risk.0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.5K Banking & Borrowing
- 254.1K Reduce Debt & Boost Income
- 455K Spending & Discounts
- 246.5K Work, Benefits & Business
- 602.8K Mortgages, Homes & Bills
- 178K Life & Family
- 260.5K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards