s92bhadauria
New Member
Hi there,
I have been using Google Forms to get some data from users. This is the output.
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
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.
I have been using Google Forms to get some data from users. This is the output.
Time stamp | city | week | Select condition | Cost | Comment |
1/13/2023 18:19:53 | london | W02 | A | 1 | good |
1/15/2023 20:55:02 | berlin | W02 | A | no good | |
1/15/2023 20:56:58 | berlin | W02 | C | 22 | waste |
1/15/2023 20:59:23 | berlin | W02 | B | 2 | waste |
1/18/2023 0:06:28 | london | W02 | B | ||
1/15/2023 21:35:00 | berlin | W01 | D | 3 | |
1/15/2023 21:37:10 | berlin | W02 | D | 4 | |
1/15/2023 21:43:47 | berlin | W02 | F |
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
City | Week | Cost | Comment |
berlin | W02 | 4 | waste |
london | W02 | 1 | good |
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
Last edited: