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 off, which should I believe? Secondly, why is this? The top column is only text and the bottom column is only numbers. Does that make a difference?
I'm not sure what are top and bottom columns in your case. If we speak about structured table, clicking on column you select rows between header and totals. Clicking once more data rows plus header and totals are selected, i.e. it will be two more.
- Apologies. I meant to say row.
pb108092 I doubt it, but what do you mean by "the top column" and "the bottom column"?
Riny_van_Eekelen apologies. I meant row.
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.
