Recent content by lukeh81

Hi, This might be asking too much, so if you or someone else here is unable to help, I would understand. The final structural concept of my water level measurements in Excel field sheet and database, is shown in the spreadsheet I've attached below. This is a highly simplified version and I...

Hi Aniruddah, Thank you, this is brilliant! I had been toiling away at this, and wasting valuable work time, for far too long. Much appreciated, Luke

Hi, I was not sure how to word my problem to search for a solution, so will try and describe it here using simplified tables. I have created two tables, Table A and Table B. Table A can be thought of as a master table. It is a list of water bores H1-H13, each with a hole elevation (height above...