How to AVG columns in 3d array

[jonathanupr]

I've been running into a wall on how to do the averaging of this particular VI.

What I am doing is finding the like matches of column 1 which represents RPM, and then go ahead and avg the data in each corresponding columns....then kick out the data with only the 1 particular RPM pt. and not multiple pts (655 and not 655a, 655b).  See the attached VI on being able do to this with selecting the Max value.

For example:

RPM           Ch1               Ch2                

655           5                     3

655           4                     3.5

654           3                     2

653           3.5                  1

653           3                    11

653           2                     7

Help would be great thanks.

[jonathanupr]

Here's the Max Value Readings vi with actual data within the arrays.

[Darin.K · Accepted solution]

Here is my seat-of-the-pants version.  I couldn't open your VI on this machine, my example finds matches in Col 0 (your col. 1) and finds the average and max values in the other columns.  Please check for errors.

[jonathanupr]

looks good.  thanks