excel 2003 - office professional.
I have data for water temperature from two reservoirs taken over 5 years. I
want to match the water temperatures from the two reservoirs only for samples
taken on the same day as not all samples were taken at the same time. I
therefore have four columns: 1) date of sample for reservoir 1; 2) nitrate
reservoir 1; 3) date of sample reservoir 2; 4) nitrate reservoir 2.
There are uneven sample numbers for each reservoir where there was some data
missing from one of the reservoirs.
Many thanks