Maddening Dilemma - Compare each cell within column a to each cell
I don't have time to code this for you, but a VBA solution could work
along the lines of:
add a sequence to column B
sort the data in both columns in (say) descending order of column A
(all the positive numbers will come first, down through zero then
negative numbers)
start looking at both ends of the list with two variables - top and
bottom
if cell(top) = cell(bottom) then colour both cells: increment top:
decrement bottom
else if cell(top) magnitude of cell(bottom) then increment top
else decrement bottom
do this until top=bottom
re-sort the data back to how it was using sequence in column B
delete column B.
Hope this helps.
Pete
On Sep 30, 7:07 pm, wrote:
Pete,
Thanks so much for your attempt at this problem.
It is very important that all of the positives cancel with all of the
negative and leave the unique values untouched. A -10 should only
cancel with a single +10, etc...
I have tried a variation of the suggestion you offered, and though it
works in a case where this does not come into play, my needs require a
very accurate canceling of unique opposing values.
I wish there was a way i could just post the raw list of values i am
working with so it would be easier to understand.
Thanks again for your help Pete.
|