Hello everyone;
Not too long ago one of you helped me with a beautiful formula to plus/minus digits equaling a specific value, with a TRUE/FALSE result:
=OR(ABS(Y8-Y11)=ABS(30),ABS(Y8+Y11)=ABS(30))
I use it to identify two numbers from several rows of digits to equal a specific value. My data is setup with “conditional formatting” to highlight
the digits the formula finds. Now I want to take it a little further. I’d like a formula which copies these two highlighted digits to two new cells.
It does not matter if the new formula is a modified version of my present formula or if its a separate formula; placed into the new cells my
highlighted digits would occupy.
I hope this is possible and thank you in advance for reviewing my post.
Ron
( I use 2003 )
Bookmarks