Forum Discussion
Combining data when removing duplicates
Modern Excel has so many alternatives and, as yet, little guidance concerning best practice.
= SUMIFS(value,ref,UNIQUE(ref))but a whole spectrum of variations is possible, including,
= MAP(UNIQUE(ref), Sumifλ(value,ref))
where "Sumifλ" is given by
= LAMBDA(v₀,r₀, LAMBDA(d, SUM(FILTER(v₀, r₀=d))))The purpose of the two Lambdas is to allow the sum and criterion ranges to be passed as a parameter string whilst each unique ref is passed one at a time by the MAP helper function.
Hi! How are you?
I need the exact same thing, but instead of numbers there's only text.
The file has over 120 k lines and thousands of duplicates. The column A has the ID for some genetic mutations, column B has the specific trait for that mutation and column C has the bigger trait. So I have duplicates for the ID's and traits, and I would like to remove the ID duplicates, but combining the data related to it, all in one line.
Do you think you can help me?