Yogi Anand, D.Eng, P.E. Google Spreadsheet www.energyefficientbuild.com
user Estesark said:
How do I check for the last entry before a deadline?
I have a form, which people on a forum I visit use to submit answers. I have multiple sheets on the form spreadsheet to manipulate the data, but there is one thing I can't quite work out how to do: find the last entry before a deadline for each person. I need to be able to do this because if a person submits a new set of answers, the old ones are irrelevant. Because all the entries are timestamped, I can check whether they were submitted before a deadline, which I enter manually into a cell, using a simple formula such as IF(C3<=$C$2,1,0), where column C contains the dates and cell C2 contains the deadline.I can also check whether they submitted any answers afterwards with formulas likeIF(COUNTIF(E5:$E$20,E4)=0,1,0)
user Estesark said:
How do I check for the last entry before a deadline?
I have a form, which people on a forum I visit use to submit answers. I have multiple sheets on the form spreadsheet to manipulate the data, but there is one thing I can't quite work out how to do: find the last entry before a deadline for each person. I need to be able to do this because if a person submits a new set of answers, the old ones are irrelevant. Because all the entries are timestamped, I can check whether they were submitted before a deadline, which I enter manually into a cell, using a simple formula such as IF(C3<=$C$2,1,0), where column C contains the dates and cell C2 contains the deadline.I can also check whether they submitted any answers afterwards with formulas likeIF(COUNTIF(E5:$E$20,E4)=0,1,0)
----------------------------------------------------------
following is one solution to the problem
No comments:
Post a Comment