Select Page

Jupiter Solutions

- feel the power of excel with us

Have you heard about Style in Excel?

Style – an Excel feature I am covering in this post is one of the most underutilized feature of Excel. You might be thinking this feature is not so popular because, it’s not useful or this feature is very hard to learn but it’s not true. Excel is...

Find the second, third or nth match value in Excel

In one of my post, I explained why in some cases it’s better to use INDEX with MATCH then VLOOKUP (link). However, with the formulas shared/explained you can pick the value against first match only, what if you want to pick values for second, third or nth match. A...

Sum of Digits of a Number

Have you heard about numerologists? Numerologists study influence of numbers in your life. One such number is sum of digits of your date of birth. Today we will see how we can add digits of a number. The trick is to break the number in individual digits and add them....

VLOOKUP Vs INDEX with MATCH

VLOOKUP is the most widely used built-in function of Lookup & Reference group in excel. We use VLOOKUP to pick data from a table array after matching a field in the first column. Syntax for VLOOKUP is The limitation of VLOOKUP is, value you are trying to match...

Calculating Date for a Weekday in a Month

Sometime we may require to calculate the date for a particular weekday of a month. Today, we would learn to calculate the same using excel I decided to cover this topic in my blog when a reader asked me that whether it is possible to calculate the date of first Sunday...

Convert to Ordinal Number in Excel Using Conditional Formatting

Microsoft Excel is a versatile and user-friendly application, most of the time, you find more than one solution to resolve a problem In one of my post, I covered trick to convert cardinal number and date to ordinal (link) with the help of formulas. You can achieve the...

Get the required result by changing value – Goal Seek

Banks and Financial Institutions always sanction the loans based on a defined set of rules, which involves paying capacity, value of property mortgaged, age of payee, etc., inter-alia. So, while doing any financial planning, we should calculate loan amount based on...

How to count only the Unique Items in Excel

There are a number of built-in functions available in excel for counting; e.g., COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS; etc., but there is no function available to count only the unique items (like in a series 1,2,3,1,4,5,2,4 – 1,2,3,4,5 are unique). However, we...

We make our Investments with a hope that these will generate income for us, and will appreciate in future. So, naturally before taking any decision about investments, we would like to know the risk factors associated and their maturity value; i.e., how much we will...