how to select max and min?

Finding max and min

  • 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.

  • Answer:

    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.

Miningco.com Visit the source

Was this solution helpful to you?

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.