Hello,
I'm trying to calculate the maximum number in one column (Col 3) based on the common values in another column (Col 1). Example given. Thanks for your help.
Thanks. I'm trying to create a calculated column. I tried your suggestion but it only returned BLANK. Should I use something besides "xxxx" at the end of the formula? I removed the "xxxx" and it returned the largest number in the whole table for col 3.