8 Replies Latest reply on Jul 5, 2013 9:33 AM by kettan

    Why is it adding null values to the front of my data list?

    Christy Rogers

      Hello,

       

      I would really appreciate your help.  It seems like there are null values added to the front of the data.  When i click view data and the tab udnerlying data.  In the orignal file, there are no null entries.  Having them is messing up the sum.  I am trying to add the output from Calculation1 for a total number of points.  the total should be 22, but it has a null value with a calculation1 value of 3 that is also being added.  How do i fix this?

       

      Workbook: fake10data

       

       

      Thanks,

       

      christy

        • 1. Re: Why is it adding null values to the front of my data list?
          kettan

          I believe the reason is found in FakeSampleData10.xlsx.

          If you attach it, I could confirm if my suspicion is correct or not, and if yes, tell you why you get nulls.

          • 2. Re: Why is it adding null values to the front of my data list?
            Christy Rogers

            fakeData10screenshot.PNG.png

            I can't figure out how to attach a file.... Here is a screenshot of the data

            • 3. Re: Re: Why is it adding null values to the front of my data list?
              kettan

              I forgot how tricky it is to attach files.

              First you have to choose <Use advanced editor> and then <Attach> in the bottom right corner.

               

              Can you quickly check which row in FakeSampleData10.xlsx becomes active after pressing Ctrl + End?

              If it is row 32 (rather than row 11), then we know that something is in the "empty" rows.

              The solution is to mark these "empty" rows and delete them.

              • 5. Re: Why is it adding null values to the front of my data list?
                Dana Withers

                I downloaded your workbook but when I press CTRL+END - it does end in line 32.

                Perhaps remove empty lines as suggested?

                • 6. Re: Re: Re: Re: Why is it adding null values to the front of my data list?
                  kettan

                  My suspicion is hereby confirmed, because pressing Ctrl+End activated row 32.

                  I have deleted the rows and attached the spreadsheet in this comment.

                   

                  Ps.When looking at the sheet data in XML, we see that some formatting is stored in the "empty" rows:

                   

                  <sheetData>

                  <row r="1" spans="1:2" x14ac:dyDescent="0.25"><c r="A1" t="s"><v>0</v></c><c r="B1" t="s"><v>1</v></c></row>

                  <row r="2" spans="1:2" x14ac:dyDescent="0.25"><c r="A2" s="1"><v>41456.000694444447</v></c><c r="B2"><v>1</v></c></row>

                  <row r="3" spans="1:2" x14ac:dyDescent="0.25"><c r="A3" s="1"><v>41456.001388888886</v></c><c r="B3"><v>2</v></c></row>

                  <row r="4" spans="1:2" x14ac:dyDescent="0.25"><c r="A4" s="1"><v>41456.002083333333</v></c><c r="B4" s="2"><v>3</v></c></row>

                  <row r="5" spans="1:2" x14ac:dyDescent="0.25"><c r="A5" s="1"><v>41456.00277777778</v></c><c r="B5"><v>4</v></c></row>

                  <row r="6" spans="1:2" x14ac:dyDescent="0.25"><c r="A6" s="1"><v>41456.003472222219</v></c><c r="B6"><v>5</v></c></row>

                  <row r="7" spans="1:2" x14ac:dyDescent="0.25"><c r="A7" s="1"><v>41456.004166666666</v></c><c r="B7" s="2"><v>6</v></c></row>

                  <row r="8" spans="1:2" x14ac:dyDescent="0.25"><c r="A8" s="1"><v>41456.004861111112</v></c><c r="B8" s="2"><v>7</v></c></row>

                  <row r="9" spans="1:2" x14ac:dyDescent="0.25"><c r="A9" s="1"><v>41456.005555555559</v></c><c r="B9"><v>8</v></c></row>

                  <row r="10" spans="1:2" x14ac:dyDescent="0.25"><c r="A10" s="1"><v>41456.006249999999</v></c><c r="B10" s="2"><v>9</v></c></row>

                  <row r="11" spans="1:2" x14ac:dyDescent="0.25"><c r="A11" s="1"><v>41456.006944444445</v></c><c r="B11"><v>10</v></c></row>

                  <row r="12" spans="1:2" x14ac:dyDescent="0.25"><c r="A12" s="1"/></row>

                  <row r="13" spans="1:2" x14ac:dyDescent="0.25"><c r="A13" s="1"/></row>

                  <row r="14" spans="1:2" x14ac:dyDescent="0.25"><c r="A14" s="1"/></row>

                  <row r="15" spans="1:2" x14ac:dyDescent="0.25"><c r="A15" s="1"/><c r="B15" s="2"/></row>

                  <row r="16" spans="1:2" x14ac:dyDescent="0.25"><c r="A16" s="1"/></row>

                  <row r="17" spans="1:2" x14ac:dyDescent="0.25"><c r="A17" s="1"/></row>

                  <row r="18" spans="1:2" x14ac:dyDescent="0.25"><c r="A18" s="1"/></row>

                  <row r="19" spans="1:2" x14ac:dyDescent="0.25"><c r="A19" s="1"/></row>

                  <row r="20" spans="1:2" x14ac:dyDescent="0.25"><c r="A20" s="1"/><c r="B20" s="2"/></row>

                  <row r="21" spans="1:2" x14ac:dyDescent="0.25"><c r="A21" s="1"/><c r="B21" s="2"/></row>

                  <row r="22" spans="1:2" x14ac:dyDescent="0.25"><c r="A22" s="1"/><c r="B22" s="2"/></row>

                  <row r="23" spans="1:2" x14ac:dyDescent="0.25"><c r="A23" s="1"/><c r="B23" s="2"/></row>

                  <row r="24" spans="1:2" x14ac:dyDescent="0.25"><c r="A24" s="1"/><c r="B24" s="2"/></row>

                  <row r="25" spans="1:2" x14ac:dyDescent="0.25"><c r="A25" s="1"/><c r="B25" s="2"/></row>

                  <row r="26" spans="1:2" x14ac:dyDescent="0.25"><c r="A26" s="1"/><c r="B26" s="2"/></row>

                  <row r="27" spans="1:2" x14ac:dyDescent="0.25"><c r="A27" s="1"/><c r="B27" s="2"/></row>

                  <row r="28" spans="1:2" x14ac:dyDescent="0.25"><c r="A28" s="1"/><c r="B28" s="2"/></row>

                  <row r="29" spans="1:2" x14ac:dyDescent="0.25"><c r="A29" s="1"/><c r="B29" s="2"/></row>

                  <row r="30" spans="1:2" x14ac:dyDescent="0.25"><c r="A30" s="1"/><c r="B30" s="2"/></row>

                  <row r="31" spans="1:2" x14ac:dyDescent="0.25"><c r="A31" s="1"/><c r="B31" s="2"/></row>

                  <row r="32" spans="1:2" x14ac:dyDescent="0.25"><c r="A32" s="1"/><c r="B32" s="2"/></row>

                  </sheetData>

                  • 7. Re: Re: Re: Re: Why is it adding null values to the front of my data list?
                    Christy Rogers

                    thanks so much for your help! maybe i messed up because i don't have an end button i used the down arrow.   I really appreciate your time.

                    • 8. Re: Why is it adding null values to the front of my data list?
                      kettan

                      I am glad I could help.

                       

                      Ps. Please stamp one answer as correct, so other helpers searching for unanswered questions don't need to spend unnecessary time on those already answered.

                      I also get happy when an answer of mine is marked green as correct answer