Maximum and minimum value in Excel?

Question

I know everything is possible in Excel it's just knowing how! I have a cell containing a DDE link to a share price and formula to give value of my holding (so value constantly changing). Just for fun I would like another cell to show the maximum and minimum values as they are hit. Like those thermometers that give you max and min temperatures.

Update:

Thanks Little.. Don't understand a word of your answer!! GenStat is a program, right? Do you not think I can achieve what I want just using Excel?

garbo7441 · Accepted Answer

I would believe, since the value is constantly changing, that you could employ a WorkSheet_Change event handler to handle this fairly easily.

In essence, assign your cells to hold the min and max values, say D1 for Min and E1 for Max.s

Then, when the Change event fires, upon data change on your DDE linked cell, check the value against both D1 and E1. 

If the DDE cell value is less than the current value in D1, replace the current value in D1 with the value in the DDE cell.  

Similarly, if the value in the DDE linked cell is greater than the value in E1, replace the current value in E1 with the value in the DDE linked cell.

? · Answer

When writing to Excel, Quattro or Lotus 123 for Windows, GenStat will automatically extend the Item range to take into account the spreadsheet changing in size. Then, use Max or Min function on an array.
:)

Trending News

Maximum and minimum value in Excel?

2 Answers