Anybody able to help with this one please:
- I have a sheet of users (name, email, photo etc)
- A user can submit a request and these are stored in a sheet of requests
- Each request includes a column for the user email and a date when they submitted it
I want to add a column to my users sheet that shows the most recent date that the user submitted a request. I had thought that the MAXIFS function (used as an ARRAYFUNCTION) might achieve this for me but I can’t get it to work.
I am using it like this:
'UserRequests'!C2:Cis the column in the requests sheet containing the date
'UserRequests'!A2:Ais the column in the requests sheet containing the user email
B2:Bis the column in the users sheet containing the user email
So I’m saying, in the users sheet, go find the largest value in the date column from the requests sheet where the user email in there matches the user email in here.
I think the problem lies with the final “match” part of the MAXIFS function i.e. “=”&B2:B and I’m wondering if a range is not supported here? Difficult for me to provide the actual sheet as it has client data in it. Apologies.
Any help greatly appreciated.