How to find variable in the same Longitude and Latitude for Excel

4 views (last 30 days)
Farshid Daryabor
Farshid Daryabor on 10 Oct 2019
Edited: Michal on 11 Oct 2019
I have a xlsx matrix size (9884*21), I'm trying to manage a matlab code to find the exact value position in the each row corresponding to the longitude and latitude, for example; And I want to save them in new file accordingly.
I appreciate any support
No. Value Lon Lat
1 a i j
2 b ii jj
3 c iii jjj
4 d . .
5 e . .
6 f . .
7 g . .
8 . . .
. . . .
. . . .
. . . .
. . . .
. . . .
9884
  5 Comments
Michal
Michal on 11 Oct 2019
Are you trying to find the row number of a specific set of latitude and longitude? So, using your example table above, if your longitude is ii and latitude is jj you are hoping to get the number 2 (i.e. 2nd row; assuming we are skipping headers) so you can then extract all the information (i.e. the values of all the other columns) that can be found in that row?

Sign in to comment.

Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!