Posts

Post has attachment

Post has attachment

**Row and column sum by easy formula**

Row and column sum by easy formula. By this formula easily know rows sum and column sum are equal or not . This formula easily identify rows sum and column sum right or wrong. Formula is:(row number and column number change as your wish) IF(SUM(A7:E7)=SUM(F...

Add a comment...

Post has attachment

Unique value find easily............

Post has attachment

**Unique Value Easily Identify**

Unique value easily Identify by conditional formatting a formula . Some time we are need only unique value from report ,If this report range large difficult to manually find unique value. so ,we are use this formula. COUNTIF(A:A,A1)=1 At first click menu ba...

Add a comment...

Post has attachment

Manually every page break insert row than subtotal is difficult ,if many page in a report .if we use this VB code easily solve this problem . please so this link........

Post has attachment

Post has attachment

Add a comment...

Post has attachment

Add a comment...

Post has attachment

Add a comment...

Post has attachment

Add a comment...

Wait while more posts are being loaded