Dear users
I have "RES Points" Chainage and "Start and End TP/IP" Chainage, help me detecting the nearest TP/IP
Please see attached Excel
Thank u
Dear users
I have "RES Points" Chainage and "Start and End TP/IP" Chainage, help me detecting the nearest TP/IP
Please see attached Excel
Thank u
I dont think you have explained what you want so well, but the below may be what you require
you find the values above and below the value in question, and work out the difference between the and the valuePlease Login or Register to view this content.
then as a result of this you chose the value in column g for whatever is smallest
I need the nearest matching chainage (Answer in Column d and e) with respect to data in column g and h. I have made four samples. plz
Did you try the solution I gave, on your new sheet it is in d3
=IF(B3-LOOKUP(2,1/($H$3:$H$946<=B3),$H$3:$H$949) < INDEX($H$3:$H$949,MATCH(TRUE,B3 < $H$3:$H$949,0))-B3,LOOKUP(2,1/($H$3:$H$949 <=B3),$G$3:$G$949),INDEX($G$3:$G$949,MATCH(TRUE,B3 <$H$3:$H$949,0)))
and in e3
=IF(B3-LOOKUP(2,1/($H$3:$H$949<=B3),$H$3:$H$949) < INDEX($H$3:$H$949,MATCH(TRUE,B3 < $H$3:$H$949,0))-B3,B3-LOOKUP(2,1/($H$3:$H$949 <=B3),$H$3:$H$949),B3-INDEX($H$3:$H$949,MATCH(TRUE,B3 <$H$3:$H$949,0)))
Last edited by davsth; 08-31-2021 at 06:40 AM.
Thank You @davsth, it's working
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks