Finding max and min

QuestionEdit

I have a problem I need help with.

I have a row of numbers on the top row. i.e. 15 20 25 40 50 80 100 150 200 250 300 400 450 500 600 750.

I would like to fill up the min and max column with numbers such that for the 3rd row, min will be 50 and max will be 100 since there are numbers at the column 50 and column 100 that covers the min and max.

in the case of the 4th row, it would be 50 for min and 150 for max.

for 6th row, min and max would be 50. for the last row, it would be 50 for min and 100 for max.

the min and max values are based on the first row.

how do i write a macro or formula to accomplish this task?

your help will be greatly appreciated.

AnswerEdit

Sorry I don't quite understand your question.

"I have a row of numbers on the top row. i.e. 15 20 25 40 50 80 100 150 200 250 300 400 450 500 600 750.

I would like to fill up the min and max column with numbers such that for the 3rd row, min will be 50 and max will be 100 since there are numbers at the column 50 and column 100 that covers the min and max."

Kindly rephrase the question.