Hello everyone, This is my first post here. I'm relatively new to using the deeper functions of excel. I have a little bit of experience with coding, but I typically only do so to make small programs that will make personal tasks more efficient.
I have a workbook that I am using for automotive tuning. The end goal is to take user entered data consisting of 3 elements per row, compare that data to a 17*17 table, calculate an average correction factor for each point, and apply that correction factor to the original table, yielding a corrected map that can then be loaded onto the ECU of the car.
I have done this using the following VBA code:
Please Login or Register to view this content.
The issue I am having is that if the function encounters a set of data (or Column A and Column B combination) that lands it in the same cell as the previous cell, it does not add to my total correction table or visits table. IE if I had a set of data 50000 rows long where the index values of all data points to the same cell in my table, but provides a different correction factor for each sample, it only takes into account the first value and does nothing with the rest. If the function has to move to a new cell, and then back to a cell it has already visited, it works just fine however.
Also, unrelated: in my Histogram Sub, I could not get the loop to work properly by using
Any pointers would be greatly appreciated. As far as my logical reasoning skills tell me, Sub should do exactly what I wanted it to do, so I'm completely stumped. Thanks in advance!Please Login or Register to view this content.
Bookmarks