Needs VBA


Rows(Application.Min(Columns(5))).Copy

for column E

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Cletus Stripling" wrote in message
...
Is there a way in Excel to use the Min function to determine the minimum
value in a column, and copy that entire row to a new area of the
spreadsheet?

For example,

In my sheet I have multiple columns of data. I want to determine the
smallest value in column c but then I want to copy that entire row of
data to a new area.

thanks in advance