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...

read more

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....

read more

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...

read more

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...

read more

Maturity Value of Your Iinvestment

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...

read more

Anything and Everything in Excel!

Are you scared stiff of any topic in excel?

Share With Us

Pin It on Pinterest

Share This