Hi all,
I need Excel to find all peak values in Column B and report their value and corresponding data that is listed in Columns C and D. After searching the internet, I've used countif to determine the number of peak values and vlookup to find the first peak value, but I'm having difficulty with trying to get Excel to report all occurrences of max values. Unfortunately, the location of the subsequent peak values do not occur systematically.
If it helps, here's a sample of what I have thus far. Any help would be greatly appreciated.
Thanks,
Chad
Bookmarks