Referring to a spill in another formula
You can reference a spilled range in a formula. That way, whenever the spilled range changes size, your referencing formula automatically includes all the data. Above we have a filter formula that is spilling down four rows. Above we have a Unique formula that is referencing the spilled range. Note the # in the reference. […]