=MIN(Q1:Q4000)
=MAX(Q1:Q4000)

"Karen Smith" wrote in message
...
If I have a column of #'s and i want a formula to tell me what is the
least #
in that column (to be put on another page) how would I do that? To be
more
specific, the formula i need is:

rows in detail from 1-4000

if column I = advertising and
if column Q is not empty
then tell me of those in the range, what is the lowest #

also need for highest #