ChatterBank9 mins ago
Excel Question
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?
Answers
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.If you've got loads of them you want to select, click the first one, then shift-click the last one and before you let go of the shift key, again, it'll tell you how many you've selected in the little box on the left near the top.
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.