Hello,
I want to select the first recorded start date and the final recorded end date of clients with multiple entries (they can move across various locations in our housing service) to calculate the total number of months they were housed. Most clients have a single entry but many have multiple entries.

I have looked at using the XLOOKUP and AND functions… Any ideas? See screenshot.

​Hello,I want to select the first recorded start date and the final recorded end date of clients with multiple entries (they can move across various locations in our housing service) to calculate the total number of months they were housed. Most clients have a single entry but many have multiple entries.I have looked at using the XLOOKUP and AND functions… Any ideas? See screenshot.    Read More

​