Forum Discussion
Duplicate Columns
So, I'm new to using Excel and I've been trying to figure something out. I'm doing an Excel sheet of people who donated to a fund with their names and the amount they donated. My issue is there are ...
If you are using Excel 365, there are some newish worksheet functions that will also do the job. Given the two columns 'name' and 'donation', a list of distinct names is given by the formula
= UNIQUE(name)
and then the donations for each distinct name are given by
= SUMIFS(donations, name, distinct#)
[Note: If the name 'distinct' is applied to the first cell containing the formula, 'distinct#' will be its spilt range)
Thank you for your help! I will try this out.