Hi,
I am trying to get values within range from below table
| | Site1 | Site2 | Site3 | Site4 | Site5 | Site6 |
| City1 | 556.6862 | 281.4253 | 394.1862 | 207.4911 | 1313.492 | 523.6804 |
| City2 | 561.1425 | 286.2486 | 398.0048 | 209.8744 | 1316.507 | 520.5825 |
| City3 | 548.1638 | 277.3482 | 399.6847 | 193.9866 | 1300.695 | 515.9695 |
| City4 | 558.8382 | 283.7867 | 396.1085 | 208.5752 | 1314.903 | 522.0923 |
| City5 | 658.863 | 586.9552 | 814.3368 | 343.7025 | 1075.604 | 245.5309 |
| City6 | 561.9312 | 284.4052 | 391.6543 | 215.2484 | 1320.906 | 527.8075 |
| City7 | 546.524 | 269.4021 | 382.9755 | 204.2632 | 1308.027 | 533.6238 |
| City8 | 655.9647 | 590.4726 | 820.0054 | 348.3954 | 1063.389 | 255.7009 |
| City9 | 660.1665 | 593.5486 | 822.5012 | 351.1468 | 1066.926 | 251.583 |
| City10 | 555.3619 | 281.2719 | 396.3016 | 204.4926 | 1310.806 | 521.0639 |
| City11 | 661.9681 | 592.3588 | 820.2817 | 349.3983 | 1072.822 | 246.4592 |
| City12 | 546.6184 | 273.6628 | 393.5157 | 196.6689 | 1302.381 | 522.3088 |
| City13 | 658.1035 | 591.6513 | 820.7714 | 349.3378 | 1065.859 | 253.0866 |
Output i am looking for is to list Sites under city , for example i am looking for which site is less then 500 KM from the city, in above case for example, site 4 and site 6 should fall under City 9,site 6 and site 4 should fall under city 13 and so on. i then want to show this table as per Cities with site listing under cities which are less then 500 KM.
Appreciate if anyone can give any idea? thanks
