Hi--I need help with writing thank you letters for donors. As a donation comes in, we enter the amount next to the persons name. What I need is a formula that totals up all the donations--sometimes it's just one per name, sometimes two or three--and then sorts the totals into ranges--$100-$249 $250-$499 above $500.
The names would then, ideally, be sorted into these categories in alphabetical order by last name--
is it possible to do this in excell? It sure would save us a lot of time, tx.
The names would then, ideally, be sorted into these categories in alphabetical order by last name--
is it possible to do this in excell? It sure would save us a lot of time, tx.