Minus from the lowest value in column

[ExcelRaceRatings]

Hi all,

I am hoping to find a formula that will subtract each value in a column (B2:B25) directly from the lowest value in that column.

Example:

Column B
59
54
56
50

Column C
B2 - B5 (59-50 = 9)
B3 - B5 (54-50 = 4)
B4 - B5 (56-50 = 6)
B5 - B5 (50-50 = 0)

The lowest value can vary where it appears in the column.

Thank you!

 

[Marcelo Branco]

C2
=B2-MIN(B$2:B$25)
copy down

M.

 

[ExcelRaceRatings]

Perfect!!

Appreciate your help!