0

I have been using Google Forms to get some data from users. This is the output.

data table 1

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.

https://docs.google.com/spreadsheets/d/1GJpSUo0vxiHhkP_CvH7AEnXqHX9UCmoZKeH4M6fz5YI/edit#gid=1377058657

Please guide me how to resolve this.

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

output required

Shazzy
  • 1
  • 1

0 Answers0