Forum Discussion

akikaplan's avatar
akikaplan
Copper Contributor
Feb 13, 2020
Solved

Solved: Mismatch in numbers using table row count

edit: I'm embarrassed, the issue was good old fashioned user error... Thanks to everyone who took a look! I'm trying to get an accurate cell count using a table row, I'm seeing a discrepancy in the re...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Feb 13, 2020

    akikaplan 

    In 43 cells you have NaN in both columns

    all of them are shown in attached file

akikaplan's avatar
akikaplan
Copper Contributor
Feb 13, 2020

Hi PReagan, I've attached the relevant columns for the month I was talking about, which gives a difference of 43 between the cell count of either column and the sum of the number counts from the two columns. I'm going to be really embarrassed if it's something simple, but I've looked for anything in the data that would cause this and I can't readily find anything. Thanks for any help you can give!

 

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Feb 13, 2020

akikaplan 

In 43 cells you have NaN in both columns

all of them are shown in attached file

  • akikaplan's avatar
    akikaplan
    Copper Contributor
    Feb 13, 2020

    SergeiBaklan, thank you! I just realized this as well. I don't know how I missed it before, but somehow dropping down to just the two columns made it much easier to see. Thank you for taking a look. 

Resources