array formula to provide all values associated with a given value

T

tschaeffer

From an Access Query. I've got a list with the unique ID's for reports, and
the next field indicates what Language they were written in.

This was from a Many - Many relationship in Excel, and many of the reports
were written in many different languages.

ReportID CountryID

1000020 Td

1000020 Tz

1000020 Ug

1000020 Zm

1000020 Zw

1000035 Ao

1000035 Mz

I've got over 10,000 records like this and would like an array formula that
for each Report ID (and i've got a separate list of those of course)
provides a listing (preferably tab or semicolon delimited) of every single
country that that report covers.

Any suggestions?

Thanks - Toby
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

many-many relationship: how to provide all values related to one record in a given field 3
Range reference in array formula 2
Problems Loading Large String Array into Array variable 6
lettter send to joanne and john 1
Calculations on values in two forms 0
What is the syntax for adding to "Blocked Senders List" to OL2K3 5
Hi all, please read this, is a great service for all people, try it and you gonna to look the result 0
A little OT - Quite a rant on microsoft.public.sqlserver.olap 1

Top