Suggest me a MATLAB code to extract particular entry from one excel file and save that entry in another excel file.

Refering to attched excel file (in .xlsx format). I have daily gridded (31 latitude 31 longitude) rainfall data of 50 years. I want to extract the evey day rainfall value of every combination of latitude and longitude and save that entry in new excel file with name of that latitude and longitude.

Answer 1

[Vishal Bhutani]

By my understanding it seems that similar issues has been asked earlier, please refer to the link attached below:

https://www.mathworks.com/matlabcentral/answers/293046-extract-rainfall-values-and-the-corresponding-date-from-a-time-series-when-it-satisfies-certain-cond?s_tid=answers_rc1-1_p1_MLT

Hope it helps.

[ANURAG SHARMA]

Thanks for the early response. But my issue is quite different from the one you have mentioned. I want to pick up rainfall value for all possible lat-long combinations which are repeating for every day. Please refer to the file I have attached.