What if you are faced with a situation where you need to calculate summations based on meeting a single criterion? And there is a quite a large set of data to work with. One way of summing the data which meets the criteria would be to use the SUM function…

Whilst the most common mode of build a rank would be with the use of RANK function, unfortunately excel does not have a function created build a ranking based on more logical aspects. Thus, unlike some function excel does not have a RANKIF or RANKFIS function (Which is something that…

In some instances you are faced with a situation of ranking a series of values, based on the largest value to the smallest value or vice a versa. Generally how most people would sort the data set base on the values either by ascending order or in descending order and…

In my line of work there are more than one point of data, and sometime, you do need to create points to lookup a set of data and return a value or a text. At the begging I used to enter these manually and then it did take more time…

Sometimes you have one set of information that you need to keep on repeating, on each row. These would sometimes be things like Departments Gender Locations Or a set of names for sales people Whilst in most instance we manually enter these over the time, we would also make mistakes…

In the resent past I have been seeing many charts that looks cool to the eye, and was wondering whether I could create this on Excel. One such chart is the “Wind Rose Chart”, or sometimes known as the “Circular Bar Chat”. …

How many of you have struggled to find the number of years, months and days between two dates. I am sure many have which includes me. Specially when you need to be precise in your calculations. Almost all of us have been doing this manually with three different calculations, fist…

I often have worksheets where a there are columns representing the dates of the month. In the with certain data is marked from date to date in rows below the days being indicated. Whilst I have to enter data, based on the date we do have to colour and indicated…

Sometime back a young one who is know to me in a finance division asked me how do I do an aged analysis of receivables. My first question to him was how did you do it? His answer was that he calculates the number of days between due date and…