Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have a list of ~100 values in a column. I want to find all possible differences among cells of a value of 30 +/- 2. For example, 1200, 1201, 1205, 1208, 1230. The difference between values 1 and 5 and 2 and 5 would be found.

share|improve this question
    
Transpose the cells in the column into the top row, by paste special and paste value. Then subtract the absolute value and drag the formula until you reach the last column and row. =ABS($A2-D$1) Then conditional formatting, highlight cell rules, between...28 and 32. –  Jason Dec 17 '12 at 18:28

1 Answer 1

"Transpose the cells in the column into the top row, by paste special and paste value. Then subtract the absolute value and drag the formula until you reach the last column and row. =ABS($A2-D$1) Then conditional formatting, highlight cell rules, between...28 and 32." (OP)

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.