I'm trying to create a macro to do a variety of functions. The data set I'm working with is generate from a Fuel Injection ECU. Once a test run is done, the data is exported into Excel. I end up with four columns of data, Time Stamp, MAP, RPM, and O2 Reading.
The Time Stamp column is deleted, then the MAP value is rounded to the nearest multiple of 10 using MRound, RPM is rounded to the nearest multiple of 100 using the same function, and the O2 Reading is rounded to the nearest 2 decimal places.
I then swap columns A (MAP) and B (RPM) so RPM is in column A, followed by MAP and then O2 readings.
I then pull off each set of RPM data and insert it into a new worksheet labeled with the RPM data.
Once the data set for a certain RPM range is in the new worksheet I then sort the data according to the MAP data and separate out the initial columns into the different MAP ranges. Finally I average the O2 reading for each MAP range at that RPM.
The data sets are very large with anywhere from 1000-5000 entries so as you can imagine it takes awhile to sort through this by hand.
Any help, sample codes that I could piece together, etc would be appreciated.