Exel Help Please...
- Thread starter qazmax
- Start date
These are the sort of things that are very hard to discover on one's own without some external prodding. I've found many valuable tidbits on the MrExcel website, including the following :
http://www.elitetrader.com/vb/showthread.php?s=&postid=403901#post403901
Once again, good stuff.
http://www.elitetrader.com/vb/showthread.php?s=&postid=403901#post403901
Once again, good stuff.
HI,
exel accumulator works but ther is another problem:
In cell A1 i receive real time data that chenge periodically and that data accumulate in A2. For example: if in A1 we have 3 numbers (1,2,3) it is correct in A2 to see sum=6 but when A1 shows first number and waiting for second, A2 accumulate first number many times until it is waiting second number -> (1+1+1+1+1 .... +2) and that make total sum in A2 incorrect.
How i can fix that?
thx a lot.
exel accumulator works but ther is another problem:
In cell A1 i receive real time data that chenge periodically and that data accumulate in A2. For example: if in A1 we have 3 numbers (1,2,3) it is correct in A2 to see sum=6 but when A1 shows first number and waiting for second, A2 accumulate first number many times until it is waiting second number -> (1+1+1+1+1 .... +2) and that make total sum in A2 incorrect.
How i can fix that?
thx a lot.