With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Wednesday, February 6, 2013
yogi_Pull Selected Field Entries For A Date (from DateTime column) Before The Specified Date
Google Spreadsheet Post #1017
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MIwww.energyefficientbuild.com. Feb 06, 2013 post by user: alexander stanton said:(http://productforums.google.com/forum/?zx=pk24ifk32f07#!category-topic/docs/spreadsheets/UUUqTl9-Gtw) the solution in this post supplements the solution to the following problem Finding Last Date before today I'm Trying to come up with a formula to return the last date before today with an extra criteria.
this array has dates before and after today with different people, I'd like to be able to get the last date before today for frank
I'd like to also be able to look up the data in the third column for a certain person and date
Sorry for the confusion. What I mean is the last date before today for frank, and the contents of column c for that date.
So it should return 1/25 and 'did a funny dance' Since today is 2/5 If today were 2/10 it would return 2/7 and 'n/a' --- the following solution was prompted because Alex was having difficulty implementing the solution I had provided earlier to his real data as he mentioned in the following
I've tried it in test file after test file and it keeps working perfectly, but for the life of me I can't get it to work on the actual data. I've removed any private information, here is the actual file: