Trying to consolidate data for a drop down list

[tpollock]

I have attached a file that i am trying to do a drop list for. I will be doing a drop down list for each column. When i do the drop down list i will only want 2014/GMC/Sierra 3500 HD to show once. Then SLE/SLT/WT to only show once and so on. I dont know if this can be done any help would be great. Thanks

Book1.xlsx

[zbor]

You need to create unique list somewhere in the sheet and then list from that extracted list.

[tpollock]

Is there a easy way to do that i have over 215262 records.

[AlKey]

You can use Advanced Filter located under the Data tab in Excel 2007 to get unique records.

[zbor]

Something like this?

(You can, of course, hide that sheet)

[tpollock]

So if i hide the sheet i would have to write the forumla for each item correct. Thanks

[zbor]

Sorry, I've just noticed:

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[tpollock]

Sorry about that zbor. Fixed it thanks.

[zbor]

Yes, you need to filter each data and then add range name in name manager for each data and use it in your validations.