determine lead/lag times between series

Hello everyone,

I have two data series (two columns, ~600 rows long each) and I'm looking to find out some information between them.

I need to figure out how to:
- determine where each series peaks and troughs (there are many peaks and troughs)
- determine the lead/lag time between these peaks and troughs. i.e. when series one peaks series two peaks X months later (each row represents a month)

I am absolutely stumped as to how to do this (as I am new with Excel)


Thanks!
Henry

Hi Ron, Thanks for the response! I couldn't quite get your formula to work but my friend managed to get another one to ! The other part which I am stumped on is how to determine lead/lag times.

right now i have 2 series.
Series 1 (supposedly a leading indicator) and Series 2. I have a read out in Column D for Series 1 peaks/troughs (data is displayed as either 'Peak' or 'Trough' for each relative maximum or minimum) and Column G displays the same type of data for Series 2. I'm trying to figure out how to determine the lead/lag time of series 1 vs's series 2 (series 1 theoretically leads series 2).