Menu
Good evening ! I am wondering if Excel provides a built-in function that can calculate the maximum of the difference of a list of data.
For example, we have 1, 2, 3, 2, 1. The maximum difference is 2 (3 - 1). I know how to make this function with a formula, but if Excel provides something to do that directly, that would be interesting.
Thanks !!
536
When comparing two lists of data, select both columns of data, press F5 key on the keyboard, select the “Go to special” dialog box. Then select “Row difference” from the options. Matching cells of data across the rows in the columns are in white color and unmatched cells appear in grey color.
Use this:
Max(data_scope) - Min(data_scope)
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
