| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Table Relationships | Excel Discussion (Misc queries) | |||
| Graphing 3 Relationships | Charts and Charting in Excel | |||
| View the table relationships in a database | Excel Programming | |||
| Relationships / Calculations | Excel Discussion (Misc queries) | |||
| Table relationships in Excel? | Excel Discussion (Misc queries) | |||
Linear Mode
