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 #