I have an excel sheet with location data including place, id, latitude and longitude values.There are multiple rows for each combination of latitude and longitude values in which some are filled with place names and some are blank. I have to fill the blank cells in place column based on corresponding latitude and longitude combinations. Since there are more than 100 distinct places, i am trying to find a way to auto fill the blankcells. Is there a way to automate the task?
I tried to use if condition, but there are lots of places to fill and it is impossible to write the formula manually.