PC Review


Reply
Thread Tools Rate Thread

array formula to provide all values associated with a given value

 
 
tschaeffer
Guest
Posts: n/a
 
      7th Dec 2007
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


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: array formula to provide all values associated with a given value tschaeffer Microsoft Excel Discussion 2 7th Dec 2007 05:53 AM
Re: array formula to provide all values associated with a given value tschaeffer Microsoft Excel Misc 2 7th Dec 2007 05:53 AM
Re: array formula to provide all values associated with a given value tschaeffer Microsoft Excel Worksheet Functions 2 7th Dec 2007 05:53 AM
array formula to provide all values associated with a given value tschaeffer Microsoft Excel Discussion 0 7th Dec 2007 03:39 AM
array formula to provide all values associated with a given value tschaeffer Microsoft Excel Worksheet Functions 0 7th Dec 2007 03:39 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:34 PM.