Maddening Dilemma - Compare each cell within column a to each cell
To do this you need to change one line in the macro - the first IF, as
follows:
If Int(Cells(my_top, 1).Value * 10) / 10 = Int(Abs(Cells(my_bottom,
1).Value) * 10) / 10 Then
All one line - be wary of any line-breaks that the newsgroups put in.
This will not change any of your values. It merely ignores anything
beyond the first decimal place in the comparison.
Hope this helps.
Pete
On Oct 8, 2:25 pm, wrote:
Pete,
Also, as in max's example, is there a way for the macro to round the
numbers it looks for to the TENTHS (thats one decimal place) place?
As in, a value of 1001.19 is simply rounded off at 1001.1. Not like
rounding up or down, but just ignoring the hundreths place all-
together. I posted my reasoning to Max for this, so you can see up
top for a description.
If this is too difficult, forget it, but it would help!
Thanks again.
-pogster
|