Min/Max fuction to calculate difference between two ranges

[Ricker090]

I'm trying to consolidate some of the formulas on a spreadsheet. I have a range of numbers in column A and a range of numbers in column B. Currently in column C, I calculate the difference between columns B and A. In column D, I have a logical function to show if the value in C is the min difference value or the max difference value.

I would like to get rid of column C altogether and have one formula that calulates the difference between columns B and A and determines if it's the min or max of all the other differences. Is this possible with a CSE function?

I have attached a sample workbook.

[zbor]

Can't see att but Something like: =IF(MAX(B:B-A:A)=B1-A1, "Max", "")

[Ricker090]

zbor-

Unfortunately that marks every difference as "Max."

[zbor]

Comfirm with ctrl+shift+enter

[Ricker090]

ctrl+shift+enter. Yeah that did it! I always forget to do that.

Thanks so much.