Hey everyone.
here is the situation I am dealing with. I have well data that starts at different times arranged by month over several years
Jan 12 Feb 12 Mar 12 Apr 12 May 12 June 12 July 12 August 12 Sept 12 Oct 12 Dec 12 Jan 13 Feb 13 ETC
Well A 5 7 9 4 3 5 10 11 4 3 3
Well B 4 10 5 6 5 5
I would like a forumla that can identify where the first entry for the well is, and make calculations based on that number. For example, I would like to know that well A first entry is 5 (march 12), and then using that result (5) figure out how much that number has changed in 6 months.
so excel would then take that 5 (march 12)-10 (sept 12)/10(sept12). I hope there is a way to do this. Thanks so much. They actual month names dont matter just the figures.
here is the situation I am dealing with. I have well data that starts at different times arranged by month over several years
Jan 12 Feb 12 Mar 12 Apr 12 May 12 June 12 July 12 August 12 Sept 12 Oct 12 Dec 12 Jan 13 Feb 13 ETC
Well A 5 7 9 4 3 5 10 11 4 3 3
Well B 4 10 5 6 5 5
I would like a forumla that can identify where the first entry for the well is, and make calculations based on that number. For example, I would like to know that well A first entry is 5 (march 12), and then using that result (5) figure out how much that number has changed in 6 months.
so excel would then take that 5 (march 12)-10 (sept 12)/10(sept12). I hope there is a way to do this. Thanks so much. They actual month names dont matter just the figures.
