Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I hope someone has an idea on how to start this problem.
I have a lot of cyclical data that diminishes over time. I need to extract the minimum values of each cycle. I was thinking something along the line of having a start and finish value, and find the minimum value between the start and finish rows. This would repeat by setting the finish value to the start variable, and obtaining a new finish value However, I do not know how to use a variable to select a cell. If this sounds strange, I'll write a small example A B 1 5 2 4 3 3 4 4 5 5 6 4 7 3 8 4 9 5 I would initialize start to 1 and finish to 5 (the values in column A). The program would then calculate the minimum between the two values in clolumn B. Then finish (5) would become start, and 9 would be the new finish value. Any help is greatly appreciated, thanks in advance. -Taylor |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I find minimum duplicated values in a range? | Excel Worksheet Functions | |||
Find minimum value | Excel Worksheet Functions | |||
how do i find values on a line graph in Excel? | Excel Discussion (Misc queries) | |||
find minimum values in recurring ranges--expert | Excel Programming | |||
How to find the minimum value in a database with multiple values . | Excel Discussion (Misc queries) |