Return multiple unique values without using ROW

slow1911s

New Member
Joined
May 12, 2012
Messages
6
I have a list of 168 people that I am using in conjunction with a Xcelsius 2008 USA map. I'm using the map to mouse-over to enter a state code into the sheet in H1. I want to lookup all people who live in Texas, returning their names (unique) and City (could be duplicates) which I will display in text boxes. My goal is a mouse-over map that shows a list of staff names and cities in the state.

No headers
Column A: two-letter US State codes (sorted A-Z)
Column B: Last, First (names)
Column C: City Name
Column H2:H23: copies of H1 (my longest list of people is 21 names in a state)
Column I2:I23: cities that correspond to the names

I have done searching elsewhere, but, I'm not coming up with anything that fits or that I've found out how to mod for my needs. TIA.

Since I am using Xcelsius, ROW is not a supported function.
 

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top