Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default array formula to provide all values associated with a given value

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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Array formula for unique values Dan Hatola Excel Worksheet Functions 1 January 20th 07 03:06 AM
Array formula for unique values Dan Hatola Excel Worksheet Functions 0 January 20th 07 02:11 AM
lookup a list of values for an array formula Xbrokylnboy Excel Worksheet Functions 0 June 19th 06 08:12 PM
Checking 2 sets of values to provide True False Arla Excel Worksheet Functions 6 January 17th 06 11:41 PM
array formula values TUNGANA KURMA RAJU Excel Discussion (Misc queries) 1 September 29th 05 08:01 PM


All times are GMT +1. The time now is 07:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"