Function to Locate Largest Value in a Column

[rtelectric]

Hey again everyone.

I have a pretty easy [for you guys, it should be] request, although I'm too braindead to figure it out.

I have a column ("B"), and in that column, a number is being entered called "Completed to Date". The number grows, and in cell B14 I want it to automatically find the largest number in that column and divide it by a cell on a different sheet. I'm only having problems with it finding the larger number, I can do the division part.

Rereading that, it's rather messy and hard to understand. I'll give an example.

Completed to Date
5522
18901
31715
39786

I want cell B14 to automatically find the highest value in that column [in this case, 39786] and divide it by [Tracking!K6].

My only idea to accomplish this so far was to have a massive IF function:
=IF(B12=0,IF(B11=0,IF(B10=0,IF(B9=0,IF(B8=0,IF(B7=0,IF(B6=0,IF(B5=0,IF(B4=0,=B3,=B4),=B5),=B6),=B7),=B8),=B9),=B10),=B11),=B12)

I'm sure it would work if I had done it right, but I think I'm missing a part of the function at least somewhere.

[martindwilson]

=max(b1:b13)

[NBVC]

use the MAX() function

E.g. =MAX(B1:B13)/Tracking!K6

[rtelectric]

Well that was bloody simple.

Aren't I a fool?

Thanks, Martin.

[rtelectric]

And thanks for your aid as well NBVC, although you were perhaps 15 seconds late.