i have This below formula that givers me line numbers on filtered excel data
the problem is, if i have in cell D22 H1, or D1 OR any OTHER letter, next to a number, it repeats the same line numbers from the previous row.
How Can i fix that ?
=--SUBTOTAL(2,D$21:D22)
the problem is, if i have in cell D22 H1, or D1 OR any OTHER letter, next to a number, it repeats the same line numbers from the previous row.
How Can i fix that ?
=--SUBTOTAL(2,D$21:D22)