trying to find a way to show a closest to using lat and long coordinates

macropod · #20 02-08-2021, 03:25 PM

For (1), you could replace the MIN function in the formula with the SMALL function. For example:

Code:

=INDEX(Well!C:C,MATCH(SMALL(ACOS(SIN(RADIANS(B7))*SIN(RADIANS(Well!A$2:Well!A$151))+COS(RADIANS(B7))*COS(RADIANS(Well!A$2:Well!A$151))*COS(RADIANS(C7-Well!B$2:Well!B$151))),2),ACOS(SIN(RADIANS(B7))*SIN(RADIANS(Well!A$2:Well!A$151))+COS(RADIANS(B7))*COS(RADIANS(Well!A$2:Well!A$151))*COS(RADIANS(C7-Well!B$2:Well!B$151))),0)+1,0)

SMALL ,1 gives the minimum
SMALL ,2 gives the second smallest,
and so on. To get the corresponding distances, you'd make the same changes to the distance formula.

As for (2), you'd probably need to create a lookup table for the distances and use a formula to retrieve the one you're after.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Show two alternating slides as long as music plays	Magic	PowerPoint	2	11-23-2014 09:02 AM
Bad view when using Find and Find & Replace - Word places found string on top line	paulkaye	Word	4	12-06-2011 11:05 PM
Highlight and put bookmark on the closest field to the cursor	b0x4it	Word VBA	11	05-19-2011 11:15 PM
Question: Hyperlink to other show, but close the current show	habibfikri	PowerPoint	0	12-26-2010 02:37 AM
PP 2010 .avi file plays during slide show, but causes the slide show to loop to begin	VictorS	PowerPoint	0	10-16-2010 10:23 AM