Hi,
I have two cells lets say a1 and a2 both of which are continually
updating from a live feed. I would like to be able to track what the
highest number of a1 has been and what the lowest number of cell a2
has been.
Your help would be much appreciated as I am new to programming
Many Thanks
Can you send an example file ? That would help to understand better.
Thanks,
On Fri, Mar 5, 2010 at 2:09 PM, Sach1810 sach1...@googlemail.com wrote:
Hi,
I have two cells lets say a1 and a2 both of which are continually
updating from a live feed. I would like to be able to track what the
Hello Dear
Have you Tried MAX()
Please let me know,if more help required.
Hope it will Help
Happy To Help
:)
Shyam
On Fri, Mar 5, 2010 at 2:09 PM, Sach1810 sach1...@googlemail.com wrote:
Hi,
I have two cells lets say a1 and a2 both of which are continually
updating from a live feed. I
You could:
store initial values in a hidden cell.
Create a change event for the worksheet
that compares the cell contents to the hidden cells
and update if the contents meet the criteria.
(if a1 H1 then H1 = a1)
(if a2 H2 then H2 = a2)
let me know if you need help with the change events.
Decided to go to the GoogleGroups site so that I can see the whole
discussion thread.
I'll explain in detail.
To create a change event:
Right-click on the sheet taband select View Code
At the top of the editor code window is a set of pull-downs.
In the left pull-down, select WorkSheet.
It will