Hi all,
I appreciate all the help in advance. I can't seem to think of a way to work this one out so reaching out for some help.
What I would like to know is how to work out the maximum amount of books a person has had borrowed at a given time.
Example,
Person A borrows a book
Borrowed Date Return Date 01/02/2018 08/02/2018 05/02/2018 13/02/2018 05/02/2018 15/02/2018 07/02/2018 18/02/2018 14/02/2018 20/02/2018
So the result I am after is the maximum amount of books Person A has had on loan at a given time was 4.
The data I have is;
Unique Person ID, Name, Borrow Date, Return Date.
Anyone got an idea on how I could achieve this result in a formula? I don't know of a solution. I could do it manually....but given there is a couple thousand lines of data it would be difficult and time consuming.
Bookmarks