Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Gathering data - individual points for a single topic
Howdie
Hers the difficult to explain problem.... I have several bits of information, lets call them case studies. The identifying number of the case study is listed in column A. Users are required to record results for the case studies. For each case study there are a variable number of results., ie case study one could have 5 results, case study two 3 results etc. Case studies results are required to recorded on a line by line basis, So results of case study one would be listed on lines 1 to 5, and case study two, lines 6 to 9 etc WITHOUT having to manually duplicate the case study number next to each line, (because users tend only to enter the number of the case study once, ie they dont duplicate it on each line) is there an easier way of grouping the case study findings together. I cant write a formulae to reference the case study number to the line above, as that wont pick up when the case study number changes. Appreciate any thoughts or references on this topic! Thanks D *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
individual data points and group mean | Charts and Charting in Excel | |||
Gathering rows of data from multiple wrkbks to single column | Excel Worksheet Functions | |||
How do I specify min/max error bars for individual data points? | Charts and Charting in Excel | |||
Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
Calculate and display individual error bars for individual points | Charts and Charting in Excel |