1 of 1 people found this helpful
ifnull( lookuo(min([City]),0), previous(min([City]))
If it is still not working, can you share a sample workbook?
you are right, it is ok. Thank you for your support!
You can close the thread by marking any one of our answer as correct so that its get hide from unanswered list and help others who have similar query.