If you want to count text entries instead, use 3 (COUNTA) as the first argument. We’re counting dates, so the first argument, 2, tells Excel to count the numbers in the range. In our list, there will always be a date in column C, so we can use the SUBTOTAL function to count the visible dates. WARNING: Don’t use this technique if you plan to use Excel’s Subtotal feature (Data>Subtotals) - it may delete your table when you remove the Subtotals. It is designed to ignore rows that are hidden by a filter, so its result will change if rows in our list are hidden. Instead of using the simple formula shown above, if you want to show the record numbers for the visible records, you can use the SUBTOTAL function.
In the screenshot below, the second record is hidden by the filter, and the record count shows as 1, 3, 4, 5.
In column B of our list, if we just type the numbers, or use a simple formula, such as =B2+1 the numbers won’t change if the list is filtered. To make things easier for them, you can add record numbers that will print for each row.įor example, in the screenshot below, the visible rows are 2, 4, 5 and 6, and the numbers in column B are 1, 2, 3 and 4. That’s helpful if you’re looking at the results on the screen, but not much help if you print the filtered list and give it to someone else. Note: If the Status Bar shows Filter Mode, instead of the record count, you can use one of the workarounds shown here – Status Bar shows Filter Mode. When you use an Excel AutoFilter to filter a list, usually the count of visible records appears in the Status Bar, at the bottom left of the Excel window. If you filter the list, here is a way to number the visible rows in Excel AutoFilter, so they’re in consecutive order. When you create a list in Excel, do you start with a column that numbers the rows? I usually create an ID column and type the number, or use a function to automatically number them.
0 kommentar(er)
