How do I sort and extract unique entries from multiple references

Like so... data moved to top row to keep formulas simple.

The formulas in I and K are array formulas, CTRL-SHIFT-ENTER to confirm any changes you make in those formulas. I1 and K1 have a different formula than that in use below there.

Hi JBeaucaire,

thanks for the reply. I see how columns I and K are working but the dropdowns arent working the way I needed. I need the CAR MODELS to only display the cars of the selected CAR MAKE. So, if I select FORD, the only makes listed are ESCORT and MUSTANG.

Is this possible ?

Many thanks.

(p.s. in case it matters, Ive updated my profile as I'm using Excel 2010 now)

Another way to achieve this is as follows......

In order to get the sorted list of unique car makers, try this Array Formula (CSE required).

In H8

Please Login or Register  to view this content.

and copy down.

In order to get the unique models of each car maker, try this Array Formula again. (CSE)

In I8

Please Login or Register  to view this content.

and drag across and down.

For dependent drop down list in B10
Use the following formula for data validation. Data --> Data Validation -- > List --> paste the formula given below in the formula box.

Please Login or Register  to view this content.

Set a New Rule for conditional formatting of cell B10 using the below formula.....

Please Login or Register  to view this content.

and set format as Fill --> No Color, then click on Number Tab --> Custom --> Type ;;; (three semi colon) --> OK.

Glad it helped. Thanks for the feedback.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.