mardi 15 janvier 2019

Looping through two columns, storing the value if a certain conditoin is met

I'm very amateur at vba but I have two columns of data Column 1 and Column 2 - both of varying lengths

I want to choose the first value of column 2 and compare it to every value in column 1 and if error between the two is samller then one hundredths, then I want to store the text that is next to column 2 value, next to column 1. That value is then complete, then repeat for 2nd value in column 2 ... again and again

This should be able to be done in a nested for loop with an if statement.

Aucun commentaire:

Enregistrer un commentaire