Hi there,

I'm new to this forum, and a basic user of Excel, working for a non-profit. I tried to find my situation in the forum threads, but wasn't able to. I'm trying to take the last five years of donors/donations and sort them into one time, two time, etc. donors.

I need to calculate how many one-off donations we've had, and the total amount they've donated for each year. I have one column with the donor name, and five additional for the years I need to quantify.

There are nearly 800 rows of names/donations and doing it manually isn't going to work...

Any help would be greatly appreciated!

ACCESKenya