Hi,
I have a list of locations and distances for those locations. I wish to randomise 4 of those locations and sum their stances. I also wish to list the 4 random locations in one cell sperated by a comma.
I have the 4 random locations using the formulae =INDEX($A$3:$A$24, RANDBETWEEN(1, ROWS($A$3:$A$24)))
For example:
Destination Distance
Location 1 12 Location 2 [Formulae for Total Distance of those 4 Locations]
Location 2 9 Location 7
Location 3 4 Location 1
Location 4 30 Location 5
Location 5 20
Location 6 17 [4 Random Locations in one cell seperated by a comma]
Location 7 19
I would appreciate any help.
Thanks,
Verifyor
Bookmarks