If you're referring to your earlier posting
Get numbers from row

I've posted the response below in that thread
--------------------------
Perhaps something simple like this ?
(it assumes you have numbers as per your ps within row 2 to row 31)

In A32: =MIN(A2:A31)
In A33: =MAX(A2:A31)
Select A32:A33, copy across as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---