Hello, I'm trying to make a VI where it would takes data from an excel file and find the average of a second column depending on the range of the values of the first column. For example: I want to find the average of column B when column A is in the range of 5 increment Input OutputA B A C0 3.1 0 3.550 45 2.3 5 3.35 3.48 4.210 7.6 10 7.77510 7.110 8.311 8.1 I dont know how to make it so that it would automatically determine the range. I could find the average of the second column but it will just average everything and not in the 0-5 increment. Any help would be greatly appreciated Thank you, MaxMessage Edited by MaxXx on 11-16-2009 06:59 PM

LabVIEW

find average of column depends on adjacent column

Sounds like maybe you should just pass through the data once and coerce all the values that are within +/- 1 whatever specific number you care about to that specific number.

Jeff | LabVIEW Software Engineer

Message 11 of 11

(523 Views)

LabVIEW

find average of column depends on adjacent column

Re: find average of column depends on adjacent column