Thanks FDibbins,

It have not quite fixed the problem, due to me not being specific enough, sorry! I have 10 columns of data A1:A10 .... J1:J10 and I want to pick out the min and max for each column. Even if the min or max in the column is less then 10 or greater then 80 I would like it to report the min that is above 10 something like

8 It wont report the 8 in the column
12
18
80
76
150
14
min 12

I'm not even sure it is possible, and thanks very much for your help so far!!!!