Ad Clicks :Ad Views : Ad Clicks :Ad Views : Ad Clicks :Ad Views : Ad Clicks :Ad Views :

# Excel formulas and tutorials

Excel formulas and useful tools

## Determining top rankings of amounts in a range

By
|
In Data analysis
|
On September 18, 2014
Sometimes we have to know the rankings of amounts in an array or range, in order to select some of them, let’s say top 10. Microsoft Excel comes to the rescue by offering a formula to count elements that have certain attributes or meet some conditions. This function is COUNTIF and it’s result is the […]

## Two formated values in the same cell

By
|
On September 16, 2014

Sometimes you need to insert two values into the same cell. Like having the profit variation in absolute terms and in percentages in a single cell. Different format for two values in a single ce

## Format cell to show negative percent values in red

By
|
On September 16, 2014

Isn’t it nicer to see negative percent values in red color instead of all black, differentiated only by the brackets or by the (-) sign?! The format code pattern to show negative percent i

## Excel countif formula

By
|
In Data analysis
|
On September 11, 2014
Whenever you need to count the elements inside data series the excel countif formula is available to help you reach your target easy and fast. The Countif formula has the following structure: =COUNTIF(Range,Condition) Note that the Range can be a large table not only one column. Examples of Excel Countif Formula Let’s say we need […]

## Counting characters excepting spaces using excel formula

By
|
On August 27, 2014

The easy way to count the characters in a text, without counting the spaces too, is to use the LEN excel formula on a string text that has the spaces removed. Removing spaces before counting cha

## Automatic sorting using workbook formulas

By
|
On May 23, 2014

Optimizing the conclusions presented by an Excel worksheet data processing algorithm usually needs a solution for information sorting in order for it to be displayed top-down by importance facto

## Combobox VBA – populating with items

By
|
In VBA
|
On May 23, 2014
Comboboxes are user friendly data input forms that can make the difference between a quality looking form and a archaic data input screen. Defining combobox in Excel For this step you must go to the Excel Developer menu, make sure you have this menu since it doesn’t come activated in Excel Options. Select the Insert […]

## Count words in Excel using worksheet formulas

By
|
On May 21, 2014

The solution for this problem is simple. The words are separated by spaces and these spaces need to be counted in order to find out how many words there are inside the text. Worksheet formula to

This div height required for the sticky sidebar