3 Quizzes, Closing Date 30 November 2024
Quizzes & Puzzles3 mins ago
If I want to count the number of rows in a spreadsheet, I take the lowest number from the highest.
BUT - if I want to count the number of rows on a sheet which is using filters, I have to physically count, as the numbers are no longer sequential.
Is there a 'count' command of any sort which would do this for me?
No best answer has yet been selected by Chapel. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.I do not think that method would work for a filtered list... it seems to count the hidden rows. (It certainly does in Excel 2000).
Likewise the formulae ROWS and COUNTA include hidden rows in the count.
I found the only way to counteract this was to copy the selected post-filtered range to a different part of the sheet and then use any of the above methods to give an accurate count.
If you are using a newer version of Excel that does not exhibit this behaviour then ignore this post.