Hi,

I have a set of data in which i want the VBA to automatically find certain concentrated value & paste it into another column
for example as below. I want the code to look for phase 1, then detect certain concentrated value like in this case 97 - 106 meter & ignore the other value or paste it into somewhere else. For phase 2 to like 69-76 meter.

Phase Location (meter)
1 12
1 23
1 100
1 102
1 97
1 106
2 69
2 76
2 75
2 73
2 203
2 512


anyone have any idea how to do this?
thank you in advance