In this post let’s know about the OFFSET Function in excel. Also, the Syntax, how to use along with limitations and alternatives to OFFSET function. What is “OFFSET” Function in Excel OFFSET function returns the value of a cell/ range that is a specified number of rows and columns away from a cell or range …
Excel provides different types of count functions each of them suiting to different situations. As the name specifies these functions help to count the number of cells in a given range/ cells based on the specified criteria. Let us see what Count and CountA functions in excel are, syntax and how to use these functions. …
How to Use the COUNT and COUNTA functions in Excel Continue Reading »
In this post let’s see how to understand complex formulae by adding a comment in the formula. Few days back I met Kiran, a Friend of Mine. He works as an Analyst in one of the MNC’s and moved to Hyderabad recently due to a project. While we were discussing things related to our Job …
