Select Page

# Jupiter Solutions

- feel the power of excel with us

## Pulling digits from an alphanumeric string

GOAL: To pull digits from alphanumeric strings. If length and position of numeric data is fixed we can extract digits using built in functions of Excel e.g. LEFT, RIGHT and MID. Our goal is to develop a formula/ function by which we can pull digits from alphanumeric...

## Number format in Indian Style

Number format used in India is different from the international style. It’s same up to “Ten thousand” but after that it’s totally different. Have a quick view here below:   To know more about Indian number system please visit:...

## Excel Precision and Rounding errors

Excel maintains 15 digits of internal precision; however, we may choose any format of our choice to display the number in the worksheet. Suppose, all the cells in my worksheet are formatted with “comma style”; i.e., it will display only two digits after decimal. Now,...

## Gantt chart in Excel with Conditional Formatting

Just try to search out “Gantt Chart” on web once; you will get endless information. If I summarize the same – “Gantt Chart” is a type of bar chart devised by an American engineer and management consultant to represent timeline of different activities of a project....

## All about Time in Excel

A number of options are available for adding time in Excel. We may use built-in functions “TIME” or “SUM”, depending on how we have recorded the time in the worksheet. Excel allows us to capture “Hour”, “Minute” and “Second” in separate cells as well as in one too....

## Magical Mirror – An Excel Game

Let’s have some fun with excel. In today’s post I am presenting a game on excel viz. “Magical Mirror”. In fact, it’s a mind reader game; the mirror will show what you are thinking. In worksheet itself I have explained the playing rules. So, what you are waiting for?...

## Fill the blank cells with value in just above cell in Excel

There is no defined rule to capture data in Excel worksheet; however, it’s always advisable to record details in tabular form and don’t leave blank cells in between. Some users don’t want to repeat the values as shown here in the zone column below: In such cases we...

## Summary sheet in your excel workbook

There is no defined way for keeping data in excel. Excel users maintain data as desired or as they feel easier to handle. Some users keep data in one worksheet for a week while others for a month. Generally all these weekly or monthly data sheets have common formats...

## R1C1 reference style in Excel

Suppose, one day you have started excel as usual but your excel sheet column headers are appearing as 1, 2, 3 instead of A, B, C. Also when you select any cell, in name box excel displaying cell address as R1C1 instead of A1, where R stands for row and C stands for...