bilphill1994
New Member
- Joined
- Jan 24, 2015
- Messages
- 2
Hello,
I hope you guys can help me to make the following macro.
So I have two columns (x and y) I usually look at the Y column and look for values outside the range of -20 to 20. I don’t care about every value but rather the first and last in every group. For those values (first and last Y value outside of the range of -20 to 20), I want to copy the corresponding X value in another part of the sheet. I have a mac BTW if this makes any difference. Please check the picture attached for clarification. I would greatly appreciate your help.
https://www.dropbox.com/s/mhhnabn95gtkakj/screenshot for upload.png?dl=0
I hope you guys can help me to make the following macro.
So I have two columns (x and y) I usually look at the Y column and look for values outside the range of -20 to 20. I don’t care about every value but rather the first and last in every group. For those values (first and last Y value outside of the range of -20 to 20), I want to copy the corresponding X value in another part of the sheet. I have a mac BTW if this makes any difference. Please check the picture attached for clarification. I would greatly appreciate your help.
https://www.dropbox.com/s/mhhnabn95gtkakj/screenshot for upload.png?dl=0