Calculating relationships in table

's Computer Specifications

Hi!

I am trying to convert a raw data input of publications and their authors to
an output that summarizes how often the different authors have published
articles together. Could anyone please provide any help along the way on how
to do that?

Please download the example for a more detailed description of the problem.

I am using Excel 2007

The file can be found at:
http://www.quickfilepost.com/downloa...00f35f64ddaef7

Best,
Erik

's Computer Specifications

I looked over the "table counting.xlsx" sample. I understand what you are
trying to do.

This should be accomplished with macros. I do this for a living.

See my web page below.
http://members.cox.net/dennis13030/Index.htm

Dennis

"daddylonglegs-" <daddylonglegs-@discussions.microsoft.com> wrote in message
news:A996E1E9-0BC6-4836-83AD-(E-Mail Removed)...
> Hi!
>
> I am trying to convert a raw data input of publications and their authors
> to
> an output that summarizes how often the different authors have published
> articles together. Could anyone please provide any help along the way on
> how
> to do that?
>
> Please download the example for a more detailed description of the
> problem.
>
> I am using Excel 2007
>
> The file can be found at:
> http://www.quickfilepost.com/downloa...00f35f64ddaef7
>
> Best,
> Erik

's Computer Specifications

Excel 2007
This could be accomplished without macros. I do this for fun.
http://c0718892.cdn.cloudfiles.racks.../03_11_10.xlsm
Pdf preview:
http://c0718892.cdn.cloudfiles.racks.../03_11_10c.pdf

's Computer Specifications

Excellent! Thank you very much!

..Erik

"Herbert Seidenberg" wrote:

> Excel 2007
> This could be accomplished without macros. I do this for fun.
> http://c0718892.cdn.cloudfiles.racks.../03_11_10.xlsm
> Pdf preview:
> http://c0718892.cdn.cloudfiles.racks.../03_11_10c.pdf
>
> .
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Use macro's or VBA to write table relationships after import table	=?Utf-8?B?TVROQ0ZP?=	Microsoft Access External Data	2	12th Jul 2011 11:57 PM
Replace table or table data in a database; keep relationships in t	=?Utf-8?B?TWFjaw==?=	Microsoft Access	1	24th Feb 2005 06:25 PM
Make table query and Table Relationships (Notify Me)	=?Utf-8?B?TWFsY29sbSBQ?=	Microsoft Access Queries	2	7th Jan 2005 01:01 PM
Make table query and Table Relationships	=?Utf-8?B?TWFsY29sbSBQ?=	Microsoft Access Queries	0	7th Jan 2005 01:21 AM
Index out of range error when deleting rows in dataset table with relationships defined between fields in the same table	JerryK	Microsoft ADO .NET	0	19th Sep 2003 06:17 PM