Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #562 May 26, 2012 www.energyefficientbuild.com.
user Chewy3399 said:
Selecting the last data
I have a spreadsheet that a friend and I both use a form to enter data in. One column either has a value of blank, for my data, or a D for his data, what function could I use to retrieve the last entry for each of us, it can be in two separate cells.
----
Is a sample of my data, basically what I want to do is extract the time column for the last entry for D and for "Blank" and put that time stamp in another cell.
--------------------------------------------------------------------------------------------------------------------
following is my proposed solution to the problem
user Chewy3399 said:
Selecting the last data
I have a spreadsheet that a friend and I both use a form to enter data in. One column either has a value of blank, for my data, or a D for his data, what function could I use to retrieve the last entry for each of us, it can be in two separate cells.
----
Is a sample of my data, basically what I want to do is extract the time column for the last entry for D and for "Blank" and put that time stamp in another cell.
--------------------------------------------------------------------------------------------------------------------
following is my proposed solution to the problem
No comments:
Post a Comment