MAX or SUM With Group BY ID
I'm looking for a Beast Mode formula to create a MAX calculation by ID in my table. My resulting column should look like column B below. I already tried a formula with Distinct and MAX but while the formula was valid, my attempt still failed at producing desired results. Keep in mind that in my scenario, column A is a…