Forum Discussion
I Think I Found a Bug in Excel
So I was highlighting a table to see how many rows it had, and when I highlighted the top column, it told me 130, but when I highlighted the same amount on the bottom column, it gave me 128. First of...
As SergeiBaklan noted, if
= ROWS(Table1)
gives 128
= ROWS(Table1[#All])
will give 130 or 129 depending on whether the totals row is in use or not.