Numerar Celdas En Excel Con Condiciones -

=COUNTIFS(A$2:A2, A2)

This counts how many times the current category value has appeared so far in the expanding range. When the category changes (e.g., from “Fruit” to “Vegetables”), the count resets to 1. This creates perfect nested numbering: Fruit: 1, 2, 3; Vegetables: 1, 2; Dairy: 1. numerar celdas en excel con condiciones

Using LET (Excel 365):

that also ignores blanks: