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
Related Q & A:
- How to calculate max/min scales on a scatter plot?Best solution by Cross Validated
- Is it OK to increase validation checks and decrease min gradient while training neural network?Best solution by Cross Validated
- What is the bigest motor for a t-max?Best solution by Yahoo! Answers
- When is the max power event?Best solution by exhibitions.co.uk
- Is WiFi MAX Worth it?Best solution by answers.yahoo.com
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
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.