Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm having the attached data.
I need to show unique Id with minumum distance.
Please refer to the "desired out" sheet excatly what I need.
Sheet1 having the sample data.
Thanks,
Krish
Hi @krish2459 !
You have to use the FirstSortedValue() function on your "Nearest Locality" column with the expression below:
=FirstSortedValue([Nearest Locality], Distance)
and also change the column "Distance" to measure Min(Distance)
See the app attached.
Hi @krish2459 !
You have to use the FirstSortedValue() function on your "Nearest Locality" column with the expression below:
=FirstSortedValue([Nearest Locality], Distance)
and also change the column "Distance" to measure Min(Distance)
See the app attached.