Thread
:
Compare Values
View Single Post
#
2
Posted to microsoft.public.excel.programming
Tom Ogilvy
external usenet poster
Posts: 27,285
Compare Values
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.
--
Regards,
Tom Ogilvy
"Judsen Jones" <Judsen
wrote in message
...
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
Reply With Quote
Tom Ogilvy
View Public Profile
Find all posts by Tom Ogilvy