Numerar Celdas En Excel Con Condiciones (2025)
The solution lies in a counter-intuitive use of COUNTIF or COUNTA with a mixed reference. In cell B2, you enter:
that also ignores blanks:
=IF(ISBLANK(A2),"",COUNTA(A$2:A2))
This is a form of window function (similar to ROW_NUMBER() OVER (PARTITION BY Category) in SQL). It demonstrates that Excel’s grid can perform relational database operations without a database engine. This technique is invaluable for creating outlines, bill of materials (BOM) exploded views, or numbered lists inside pivot table source data. 4. The Advanced Synthesis: Combining Visibility and Hierarchy The ultimate challenge: number visible rows only, restarting the count per group, after a filter. This requires an array formula (or the new LET and FILTER functions in modern Excel). numerar celdas en excel con condiciones
The solution lies in a counter-intuitive use of COUNTIF or COUNTA with a mixed reference. In cell B2, you enter:
that also ignores blanks:
=IF(ISBLANK(A2),"",COUNTA(A$2:A2))
This is a form of window function (similar to ROW_NUMBER() OVER (PARTITION BY Category) in SQL). It demonstrates that Excel’s grid can perform relational database operations without a database engine. This technique is invaluable for creating outlines, bill of materials (BOM) exploded views, or numbered lists inside pivot table source data. 4. The Advanced Synthesis: Combining Visibility and Hierarchy The ultimate challenge: number visible rows only, restarting the count per group, after a filter. This requires an array formula (or the new LET and FILTER functions in modern Excel).