Returning Multiple Values Based on One Value

[Guest]

Sorry for creating another post, I haven't been back in a while and my
original post is burried on page 5 or 6.

I'm not the best at getting this crap to work, so bear with me. Here is an
example file that I am working with. The button brings up a list of unique
countries. Each country can have multiple assets. When you select the
country, it returns that country to whatever cell is highlighted. I then
would like the a list of assets generated based upon what was return to that
cell.

The file is at http://www.nmberger.com/nodupes.xls

 

[N Harkawat]

The formula that you have entered is not array entered (ctrl + shift + enter
instead of just plain enter)
Do this:-
Simply click on cell B1 where your formula resides
Press function key F2 on your keyboard
And press these 3 keys on your keyboard together Ctrl - Shift - Enter
You shall NOW see the formula with braces {} in front and at end after that
Copy and paste it down the column
In your example spreadsheet for Belgium I got the following assets
ACX2
ACX10
ACX15
ACX23
ACX27
ACX53
ACX64
ACX83


and a bunch of NUM# after that which can be easily eliminated using
conditional formatting

 

[Guest]

Got the formula to work, can't figure out the conditional formatting. I've
tried Cell Value Is and Formula Is and can't seem to come up with anything.