LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Find Minimum values in cyclical graph

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I find minimum duplicated values in a range? SteveMcCready Excel Worksheet Functions 2 July 15th 08 02:15 PM
Find minimum value caroline Excel Worksheet Functions 1 March 7th 08 06:25 PM
how do i find values on a line graph in Excel? sorrelponie Excel Discussion (Misc queries) 1 September 20th 05 07:35 PM
find minimum values in recurring ranges--expert xadnora Excel Programming 2 March 2nd 05 02:07 PM
How to find the minimum value in a database with multiple values . billybob1 Excel Discussion (Misc queries) 2 January 26th 05 06:11 PM


All times are GMT +1. The time now is 09:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"