=LET( visible, SUBTOTAL(103, A2), group, A2, IF(visible, COUNTIFS(A$2:A2, group, SUBTOTAL(103, OFFSET(A$2, ROW(A$2:A2)-ROW(A$2), 0)), 1), "") ) (This is a conceptual simplification; the actual implementation often requires helper columns for performance.)
=IF(A2="", "", COUNTIFS(A$2:A2, A2, B$2:B2, "<>")) numerar celdas en excel con condiciones
=IF(ISBLANK(A2),"",COUNTA(A$2:A2))
This requires COUNTIFS (or SUMIFS with a logical trick). Assume Column A is Category, Column B is Item. In C2: Ask: What is the condition
Thus, the next time you need to number a list, do not drag the fill handle. Ask: What is the condition? If the answer is “just count everything,” use the fill handle. But if the answer involves “except,” “only if,” “per group,” or “when visible,” you have entered the realm of conditional numbering—where formulas become algorithms, and rows become records. =IF(SUBTOTAL(103, A2)=1, SUBTOTAL(103, A$2:A2), "")
=IF(SUBTOTAL(103, A2)=1, SUBTOTAL(103, A$2:A2), "")