Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

"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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .