Category: Arrays

Group SUM of them

Formulas, Tutorial, Arrays, ActiveX & Form Controls, 3D-formulas

Hi there,

 

This post is a consolidation of SUM of the posts that I have wrote earlier. The reason for why I am grouping them is to let you know how many ways the simple SUM function can be used in our day to day reporting.

Let me proceed to first example:



Full story »

Difference Between - "Forecast" & "Trend"

Formulas, Arrays

Hi there,

 


What is your word on this topic?


Do you know the difference between Forecast & Trend functions? Please share your ideas in the below comments section. 


Let me explain the general meaning first:


Forecast: It is something which assumes for future. The expectations of future numbers in terms of company's growth can be called as Forecast.

 

Trend: It is something which represents for current day. Say the trend of the youth in today's generation is carrying Android Mobiles.

 

Similarly, in terms of Excel understanding: 

Full story »

VLOOKUP 2nd Version (Advanced)

Formulas, Tables, Arrays

Hi there,

 

As promissed, VLOOKUP 2nd version (advanced features) is out. 



Download working file here, VLOOKUP and HLOOKUP.xlsx


Alternative Link to the video VLOOKUP 2nd Version


WHAT YOU CAN LEARN FROM THIS VIDEO?

Full story »

Usage of Double Minus ( - - ) in Formulas

Formulas, Arrays

Hi there,

 

In this post, you will be learning why and when to use double minus -- in the formulas. Firstly, have you ever seen double minus symbol in formulas? If yes, have you ever thought why to use such minus symbols. If you know, please skip this post for now, and post your experience in the blow comments section. If you are new to it, then Here we go:

 

WHEN TO USE --?

Double minus ( -- ) will be used when the formula is delivering logical values rather than the numerical values. 


WHY TO USE --?

Full story »

sum top two values in a range

Formulas, Arrays

Hi there,

 

In this post, you can learn how to use sum function for the top two values in a range of cells. Before proceeding to what this post is about, let me show you a video explaining about this post.

 

Please leave your message in the below comments if you have different method to do this. 

Full story »

Life History of INDEX

About, Formulas, Arrays

Hi there,

 

Today, while I was browsing through google to learn new techniques on Excel, I have found a great article on INDEX function. Once you read this complete post, you will definitely say thanks to the writer. Further delaying let me share the words of the writer. Makesure you carry a meal and tea to your desk before you start reading this post, because it is bit lengthy. :)

 

The Excel INDEX function is the single most important in the roster of Microsoft Excel functions.


Now that might be surprising considering the function's humdrum name, but please pay close attention, because INDEX is one of the magical secrets of how to use Excel! So what's so great about the INDEX function? It's nonvolatile, sprightly, agile, and versatile. Excel INDEX can return one value or an array of values; it can return a reference to one cell or to a range of cells. INDEX works well on either side of the three Reference Operators - the colon, the space, and the comma.

Full story »

Contact / Help. ©2019 by Abhilash VK. Design & icons by N.Design Studio. Skin by Tender Feelings / Evo Factory.