Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compare values on sheet 1 to values on sheet2 | Excel Worksheet Functions | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
How do i compare values from two sheet and copy & paste if values match? | Excel Programming | |||
compare values between workbooks and copy values | Excel Programming |