Calculating relationships in table
 

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

Calculating relationships in table
 

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-" wrote in message
...
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

Calculating relationships in table
 

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

Calculating relationships in table
 

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

.