Excel power

Vlookup and Match Combination are the most dynamic combination which helps us to fetch the data very easily as well as we can use this formulla on multiple criteria...

Indirect and offset formulas are different formulas they dont have similar meanings We can use offset formula with choose.

Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list. In its simplest form, COUNTIF says: =COUNTIF(Where do you want to look?, What do you want to look for?)