 | Replaced Product-column(see below) with DATES as suggested. However still ERROR.
Divide by ZERO.
Excel Spreadsheet:
| |
A |
| 1 |
| Product Name: |
MSFT |
IBM |
INTC |
GOOG |
AMZN |
ZZZ |
| Oct-23 |
0.840 |
1.757 |
0.000 |
0.000 |
0.000 |
0.000 |
| Nov-23 |
0.000 |
4.300 |
4.420 |
4.560 |
4.700 |
4.840 |
| Dec-23 |
5.684 |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| Jan-24 |
0.000 |
6.652 |
3.326 |
3.326 |
3.326 |
0.000 |
| Feb-24 |
1.330 |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| Mar-24 |
0.000 |
0.000 |
0.000 |
10.520 |
10.520 |
10.520 |
| Apr-24 |
0.000 |
0.000 |
1.172 |
0.000 |
0.000 |
0.000 |
| May-24 |
0.000 |
0.000 |
3.326 |
3.326 |
3.326 |
3.326 |
| Jun-24 |
0.000 |
0.000 |
1.330 |
0.000 |
0.000 |
0.000 |
| Jul-24 |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
0.000 |
| Aug-24 |
19.800 |
0.000 |
0.600 |
0.100 |
0.100 |
0.100 |
|
|
| | Posted by [email protected] on | |