<div>
Teylyn and VipulKadia,<br />
<br />
Thank you! &nbsp;Fast, accurate, effective. &nbsp;Teylyn was 1 min. ahead in responding ;-)<br />
<br />
B.
</div>


Teylyn and VipulKadia,

Thank you!  Fast, accurate, effective.  Teylyn was 1 min. ahead in responding ;-)

B.

<div>
<div class="content wysiwyg-content">
I'm looking for a formula that will look down a column of 15 rows and find the largest number and display that number regardless of where the number falls in the column. &nbsp;<br />
<br />
Thank you in advance,<br />
<br />
B.
</div>
</div>


I'm looking for a formula that will look down a column of 15 rows and find the largest number and display that number regardless of where the number falls in the column.  

Thank you in advance,

B.

Formula for calculating last value in Column

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.