help! - multiple maximum values

[bluegitty]

Hi

I have conducted a test measuring force over time (10 millisecond intervals) giving 5000 rows of results. The force peaks roughly every 200 rows and I want to display this in a table.

If I just do a MAX (A1:A5000) I only get one maximum, if I do MAXA(A1:A5000,2) then the value is just the next reading taken from the highest peak, and not the value of the second highest peak which is about 25% less.

The peaks (roughly 20 of them) do not occur at the same point each time so I couldn't just do MAX(A1:A200), followed by MAX(A201:A401) and so on as there are several tables I have to do.

My current method is to look at the graph for the peaks to get a rough idea where they occur and then scroll through the source data until I find the highest value. That's ok for one graph but time consuming for several graphs.

Any ideas guys ?

thanks
Andy

 

[SteveO59L]

have a look at large()

 

[Peter_SSs]

Andy

Welcome to the MrExcel board!

Try this.
B1 houses a 0
Separate formula for B2
B3 copied down to end of data.
E2 copied down as far as you think you might need.

Excel Workbook
	A	B	C	D	E
1	Values	0	3		Maximums
2	5				13
3	8				15
4	9				11
5	13	1
6	12
7	15	2
8	6
9	7
10	9
11	10
12	10
13	10
14	11
15	11
16	11	3
17	8
18
High points