Compare Values

[Judsen Jones]

I am needing to compare all values in an array to see if they are within 8 of
one another. The following is a sample of the data. I need this to also
return the locations within the array by some method (Coloring the cells,
list with row and column locations, or maybe a pause for the user to write
down the locations).

Any help with this would be great.

a b c d e f g h i j
1 0 25 50 75 100 125 150 175 200 225
2 42 67 92 117 142 167 192 217 242 267
3 84 109 134 159 184 209 234 259 284 309
4 126 151 176 201 226 251 276 301 326 351
5 168 193 218 243 268 293 318 343 368 393
6 210 235 260 285 310 335 360 385 410 435
6 252 277 302 327 352 377 402 427 452 477

 

[Tom Ogilvy]

Looks like none of your numbers are within 8 of any other number. Perhaps a
revised explanation.

Look at Conditional Formatting under the Format menu.

 

[Judsen Jones]

Look at f1 and a4. The difference between these cells is 1.

 

[Tom Ogilvy]

Use a formula like this with conditional formatting:

=SUMPRODUCT((ABS($A$1:$J$7-A1)<8)*1)>1

If you just want an indicator of which cells have at least one corresponding
cell with an absolute difference of less than 8. You could apply this as a
conditional formatting formula.