Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi thanks for your reply, output representation i am after is like this
Output | |
City 9 | City 3 |
Site 4 | Site 3 |
Site 6 | Site 4 |
Site 5 |