VBA Code to find percentiles before and after the peak

[newnew125]

Hello VBA Experts,



I have multiple strain data curves that I need to analyze. The curves are log normal shaped. I would like to find the 25th, 50th, and 75th percentile values for these curves before and after the peak along with the max value. This would mean 7 total data points. The associated displacement (labeled CMOD) should also be an output below the respective load. The results should be tabulated next to the data. The data are in separate worksheets. Each worksheet has 6 columns (A-F). The data starts on row 23, column C. (Column label load). The number of rows vary for each worksheet.



For example:

Excel 2010

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
23	T	CMOD	Load	Disp	A	D			Before Peak				After Peak
24		mm	kN	mm	C	C		Percentile	25%	50%	75%	Max	25%	50%	75%
25		5	1					Load	1	2	3	4	3	2	1
26		7	2					CMOD	5	7	9	13	8	6	4
27		9	3
28		13	4
29		8	3
30		6	2
31		4	1

<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet1​

Thank you in advance for your help!