I have excel 2013, and I have two different worksheets, one the Laboratory data and the other the detection limits (same number of rows and columns). I am going to compare the Lab data with the detection limits and have the results in the third worksheet. if the lab data is greater than the detection limit, copy the lab data to the same cell in the third worksheet. If the lab result is less than detection limit, show that the data is less than the detection limits by typing, for example: <0.0005.
Thanks
Bookmarks