SLOPE formula for study results with non-continguous cells

[montyfern]

Hi You Excel Geeks! I'm flummoxed...how to use SLOPE formula for non-contiguous columns? We can click on each ending date for a study participant, but TOO MUCH data entry. Plus we forget where we were when a new date begins for the same person.

For example, the formula for CD4% slope change is=slope(P:P,C:C) and the formula for cd8% slope change is =slope(S:S,C:C). If you start with the first date when the protocol began AND there is a value for cd4% and end with the last date where the protocol ended AND there is a value for cd4%: to calculate slope for cd4% change. Then, I need to do a similar slope formula for cd8% change...same method using the first date when the protocol began AND there's a value for cd8% and it ends with the last date where protocol ended AND there is a value for CD8%.

name	date	protocol(s)	cd4%	SLOPE_CD4% CHANGE	total_c4	cd8%	SLOPE_CD8% CHANGE	total_c8	regement
Mickey Mouse
	1/1/1987
	2/22/1994		42		1048	41		1023
	5/23/1994
	8/15/1994
	11/7/1994		30		648	48		1037
	1/1/1995
	2/13/1995		31		806	49		1274
	4/1/1995								Zidovudine 04/01/1995-03/20/1997
	4/17/1995		37		780	47		990	Zidovudine 04/01/1995-03/20/1997
	5/17/1995		33		906	51		1399	Zidovudine 04/01/1995-03/20/1997
	5/20/1995								Zidovudine 04/01/1995-03/20/1997
	5/22/1995		36		1061	52		1533	Zidovudine 04/01/1995-03/20/1997
	6/12/1995		35		866	49		1213	Zidovudine 04/01/1995-03/20/1997
	7/10/1995		37		835	48		1083	Zidovudine 04/01/1995-03/20/1997
	8/7/1995		40		907	43		975	Zidovudine 04/01/1995-03/20/1997
	9/11/1995		32		817	51		1302	Zidovudine 04/01/1995-03/20/1997
	9/11/1995		32		817	51		1302	Zidovudine 04/01/1995-03/20/1997
	9/12/1995								Zidovudine 04/01/1995-03/20/1997
	9/15/1995								Zidovudine 04/01/1995-03/20/1997
	10/2/1995		37		906	48		1175	Zidovudine 04/01/1995-03/20/1997
	10/30/1995		38		806	47		996	Zidovudine 04/01/1995-03/20/1997
	10/30/1995		38		806	47		996	Zidovudine 04/01/1995-03/20/1997
	10/30/1995		38		806	47		996	Zidovudine 04/01/1995-03/20/1997
	10/31/1995								Zidovudine 04/01/1995-03/20/1997
	11/2/1995								Zidovudine 04/01/1995-03/20/1997
	11/3/1995								Zidovudine 04/01/1995-03/20/1997
	11/4/1995								Zidovudine 04/01/1995-03/20/1997
	11/6/1995								Zidovudine 04/01/1995-03/20/1997
	11/27/1995		44		1306	40		1187	Zidovudine 04/01/1995-03/20/1997
	1/3/1996		42		1332	44		1396	Zidovudine 04/01/1995-03/20/1997
	1/3/1996		42		1332	44		1396	Zidovudine 04/01/1995-03/20/1997
	1/4/1996								Zidovudine 04/01/1995-03/20/1997
	1/7/1996								Zidovudine 04/01/1995-03/20/1997
	1/8/1996								Zidovudine 04/01/1995-03/20/1997
	1/10/1996								Zidovudine 04/01/1995-03/20/1997
	1/19/1996								Zidovudine 04/01/1995-03/20/1997
	1/22/1996		49		1735	36		1274	Zidovudine 04/01/1995-03/20/1997
	2/26/1996		43		1287	43		1287	Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	2/27/1996								Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	2/28/1996								Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	2/29/1996								Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	3/1/1996								Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	3/1/1996								Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	3/2/1996								Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	3/25/1996		46		1718	36		1345	Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	4/15/1996		52		1773	34		1159	Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	4/15/1996		52		1773	34		1159	Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	4/16/1996								Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	4/17/1996								Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	4/18/1996								Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	4/19/1996								Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	4/20/1996								Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	4/22/1996								Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	5/13/1996		54		1750	32		1037	Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	6/10/1996		52		1685	36		1166	Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	7/15/1996		49		1576	38		1222	Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	7/15/1996		49		1576	38		1222	Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	7/16/1996								Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	7/18/1996								Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	7/19/1996								Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	7/20/1996								Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	7/21/1996								Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997
	8/12/1996		59		2166	31		1138	Lamivudine 02/26/1996-10/03/2000, Zidovudine 04/01/1995-03/20/1997

<tbody>
</tbody>

MUCH OBLIGED!