In Excel, if there are some values in a column which both include positive and negative values, generally, you can find the maximum and minimum values of their absolute values by using the formula combines MAX and ABS functions. But in some times, you may want to find the maximum or minimum values of their absolute values but keep their sign. In this vedio, it introduces formulas and explain how to use to solve the job. | ExtendOffice - Professional Office Add-ins