• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

latest timestamp with not null values using multiple conditions

s92bhadauria

New Member
Hi there,
I have been using Google Forms to get some data from users. This is the output.
Time stampcityweekSelect conditionCostComment
1/13/2023 18:19:53londonW02A1good
1/15/2023 20:55:02berlinW02Ano good
1/15/2023 20:56:58berlinW02C22waste
1/15/2023 20:59:23berlinW02B2waste
1/18/2023 0:06:28londonW02B
1/15/2023 21:35:00berlinW01D3
1/15/2023 21:37:10berlinW02D4
1/15/2023 21:43:47berlinW02F

I want to take this response to another sheet where I can export the latest timestamp value of the cost and comments for city and week like this

CityWeekCostComment
berlinW024waste
londonW021good

I used a a combination of index match and Max ifs functions, but was unable to get the cost value of 4 and the comment "waste" for Berlin city and week W02. Furthermore, I wanted to have the latest non-null value of cost using the conditions "city," "week," and "cost," and the same for the comment.


Please guide me on how to resolve this.
 

Attachments

  • Problem.xlsx
    9.8 KB · Views: 2
Last edited:
s92bhadauria
Your original was ... latest timestamp with not null values using multiple conditions ...
and
You're writing something about The most recent timestamp


This shows those rows as You've written with ... green.
 

Attachments

  • Problem.xlsx
    10.1 KB · Views: 1
s92bhadauria
If Your idea is to get the latest non-blank datas per city and week,
then You could get those with this sample.
... not use with Google Form ...
 

Attachments

  • Problem.xlsb
    18.4 KB · Views: 6
Back
Top