VLOOKUP and MAX

[jweeda]

I work for an electric utility and we have a request from a consumer to look at voltage for the last several months. Our electric meters store data on 15 minute increments. What I would like to do is have a summary page that would go find the maximum voltage and return the date and time from the data table that corresponds with the maximum voltage. There is a chance that the maximum voltage would register more than once during the full month. I'm assuming this would cause a conflict with the results?

Columns would be laid out as follows

Date Time Volts
4/1/13 00:00 7200
4/1/13 00:15 7240
4/1/13 00:30 7195
etc.

This will also be done with the minimum voltage.

Thanks in advance.

[lokicl]

Updated with formula. But it show only the first occurence.
There is chances of same volt recorded for various day. If you need the total no. of occurences, then you have to build a macro to filter and update.

Regards,
Loki

[jweeda]

Ok, the only thing I can see that I did different, is the layout of my data. Do I have to put the voltage in the first column of my table?

Thanks.

[lokicl]

Yes - the data for vlookup is from your left to right, else you have to use index match method.

regards,
Loki