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

Post a Comment

If any doubts let me know..

Popular posts from this blog

concrete pole specification | how to calculate cement, sand and aggregate quantity in concrete

-
Image
Today I will tell, how PCC pole concreting is done? Before knowing about our topic, let's take a little knowledge about PCC Polls.full form of pcc pole is Plain  Cement Concrete pole .There are various types of PCC Pole like 8 mtr 8.5 mtr ,9 mtr .but Now I will discuss about only 8.5 mtr pcc pole. As per Guaranteed Technical Perticulars(GTP) Total Length-8.5 mtr Pit depth-1.5 mtr Working load applied 300 mm from top-180 kg Weight of the pole-415 Kg. Top dimension-90mmx145 mm Bottom dimensions-90mm x 300 mm we have to maintain pit length is 1.5 mtr and pole should be inside pit is L/6 where L is length of the pole. Explained : L=8.5 mtr Pit depth=L/6+0.075(Base plate) Pit diameter =20 inch(0.508 mtr) Let's go to our topic now. How to calculate cement, sand and aggregate quantities for ratio 1:2:4 Pit Size For one cmt cement required -6 bag Our pit volume (dia-0.508 mtr where r-0.254, depth-1.5 mtr) Volume -pie*r2*h                =3.14*0.254*0...
Read more

Depth of Field Photography Basics

-
Image
  Depth of Field Photography Basics Understanding aperture & depth of field requires a strong foundation in the basics of a camera lens, along with the vocabulary used to describe them, such as f-stop, focal length, focus range, and field of view. This section provides an overview of the basics. The following sections provide technical details allowing you to apply these concepts to your own photography. What is Aperture in Photography? The terms f-stop and aperture are often used interchangeably, this is incorrect. Aperture refers to aperture diameter, where light enters the front of the lens. F-stop is the ratio of lens focal length to aperture diameter. F-stop can be referred to as f-number or f-stop value. They are the same. F-stop is  a dimensionless number, denoted by a hooked “ f ”, with an underlying number denoting the f-stop value. The hooked “f” is shorthand for f-stop, like the ”s.” after a shutter speed is short for seconds. f/2.8 and f/8 are two exa...
Read more

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

-
Image
A Day at the Wild Side: Sanjay Gandhi Biological Park (Patna Zoo) ​The Sanjay Gandhi Biological Park, or simply the Patna Zoo, is not just a sanctuary for animals but also a vast and beautiful botanical garden , making it a unique "biological park" that is one of the largest in the country. ​๐Ÿ“œ History and Creation ​ Initial Establishment (1969): The park was first established as a Botanical Garden in 1969. ​ The Founder's Contribution: The foundation was laid on land provided by the then-Governor of Bihar, Shri Nityanand Kanungo , who donated approximately 34 acres from the Governor's House campus. ​ Official Opening as a Zoo (1973): Over the next few years, more land was acquired from various departments, and the park was officially opened to the public as a Biological Park (combining a zoo and botanical garden) in 1973. ​ The Name: It was later named the Sanjay Gandhi Biological Park in 1980. ​๐Ÿฆ Key Attractions and Exhibits ​The par...
Read more