Hi there and welcome
Yes there are formulas so do this
You would use a lookup for this
SO for the first date you use the vlookup wit the min date
The last date would be a vlookup with the max date
Then you would also do a vlookip but with Max Amount instead of date
Then you would do a countif in order to count how many times they have provided a donation
Then a sumif to total all the donations from each client
The only changes you need to do once you have got the formula right is to repeat it for each client as the criteria.
I can also do the sheet for you, through it will be a bit of work. I have made the offer for you, if you wish for me to do this for you, please accept it and I can do this for you.
Else let me know how you go please
vlookup uses the following
=vlookup(Criteria of what to check, Where to look, Column number to return)
You would make one for each value you want to return
Then once you do this you just need to repeat it for each ID of the donor, so you repeat per each donor
ok... can you tell me please what it is you exactly require then? I provided the formulas you need to use, explained how they worked and even offered to do them for you.
Can you tell me what has not been helpful or what the issue is please?