Macro that copies maximum value from list

[Nick_1]

Hi

I need to make a macro that does the following three things:

1. Go through a range of cells. Find the maximum value in the range of cells. Copy the maximum value to another location on the worksheet. From the location of the maximum value, copy the value of the cell that is in the same row, but a different column.

I have data for conductance and time. I wish to find the maximum conductance, and the corresponding time at which the maximum conductance is attained.

2. As well, in the same list of data, there is a sudden drop in conductance. I wish to find the time at which this sudden drop happens.

3. I need to find the difference in time between when the maximum conductance data point is reached, and the time when it suddenly drops.

Does anyone know how I could go about doing this? Thanks

Regards,

Nick

[JBeaucaire]

1a) Use a MAX formula to find the max value in that column.
=MAX(C:C)

1b) Get the matching value from column B, for instance:
=INDEX(B:B, MATCH(MAX(C:C), C:C, 0))

2) & 3) Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Manually mockup the results desired from the sample data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic