SUBTOTAL(103,J$2:J2) | SUBTOTAL in excel

In excel,Suppose you want to filter column of J and maintain serial no. any time starting   from 1, 2.....then following formula.

=SUBTOTAL(103,J$2:J2)



 

Comments

Popular posts from this blog

A Day at the Zoo: Who's the Real Animal at theSanjay Gandhi Biological Park. ?"

Financial Bid Summary: NBPDCL NSC Phase-III Project

Depth of Field Photography Basics