Apr 07 2022 04:07 PM
I have two sets of data that I need to match together (observation time with corresponding weather data). I used Mround to round observation time to hourly to match weather data before using match & index to find the corresponding weather data. the problem is that this only works for 2/3 of the data, with #N/a error for the remainder. I know the data is in the table so I presume its some kind of format/data type error but have been unable to fix it.