## Need excel formula to calculate rates using dynamic skills and experience column

I want to find out the hourly rates of employees by looking up at their skills and experiences.I have a separate dataset in which all the data of the employees …

## Identify duplicates in different locations and sheets

We manufacture parts where I work, and to manufacture a part it needs to go through different work centers, and also need to go out for heat treatments or …

## How I can handle 2 different currencies for big data to the price in same currency

I have big data and I want to get the actual price by Egyptian Pound (EGP) And bearing in mind the below points US dollar \$ rate till 30-March-2015 # 7.58 EGP. …

## How to Return Absolute Value of a Number in Excel

To return an absolute value of a number in Excel requires the use of the ABS Function.  An absolute value of a number is a the number without its sign, for …

## Convert Roman Numbers to Arabic Numbers

How to convert Roman Number (LIV) to Arabic Number (54) using Execl Formula i.e the reverse of

## Count Excel Cells that Contain Data

To count how many cells contain data in Excel you use the COUNTA Function.  Using the COUNTA Function will only count the cells that are not empty. The syntax …

## Find Highest Number in a Range using Excel’s MAX Function

To quickly find the largest number in a range of cells you can use Microsoft Excel’s MAX Function that will quickly tell you the minimum number from a …

## Using Excel’s MIN Function

To quickly find the minimum number in a range of cells you can use Microsoft Excel’s MIN Function that will quickly tell you the minimum number from a …

## Using Excel’s AVERAGE Function in Excel

Microsoft Excel comes with a great function, AVERAGE, that will quickly average a range of cells that you specify. When you average numbers what you are doing …

## Adding a column in a IF function

i have an overview page. i need to add an entire column from a differant sheet if it says a certain word. the column will have 4 differant words i need to add …

## How to use SUBTOTAL Function in Excel

Excel’s SUBTOTAL function can dynamically count records in a list that has AutoFilter activated. It can also show you other information about records within …

## How to Convert Numbers into Words

What formula would be required to show the total amount, say £175.50, in words, one hundred and seventy five pounds fifty pence? I’m using Excel 2010 …

## VLOOKUP Function in Excel

A very popular, and often used function, VLOOKUP is a fantastic tool in Excel.  The VLOOKUP Function in Excel is used to look for user specified data in …

## Calculate Difference in Dates using DATEDIF Function

The DATEDIF function in Excel will calculate the difference between two dates, showing you the answer in days, months, or years depending on how you specify it …

## What is the Reason for Using the “–” Symbol in SUMPRODUCT

what is the reason for using the “–” symbol in a formula such as

## Testing for Errors using ISERROR Function in Excel

The ISERROR Function in Excel allows to test for error messages that may result from a formula. The error messages covered include; #N/A, #VALUE!, #REF!, …

## Convert Numbers to Roman Numerals

Microsoft Excel has a built in ROMAN Function that will convert arabic numbers to their Roman Numeral equivalents. The output is text based and not number …

## How to Link to a Website from Excel

Using Microsoft Excel’s HYPERLINK function allows you to link to other worksheets, workbooks, and websites. The format for the HYPERLINK function is as …

## Using Excel’s INFO Function

Using Microsoft Excel’s INFO Function we can quickly find out what operating system your PC is using. The INFO Function returns information about the …

## How to Use Excel’s WEEKNUM Function

Microsoft Excel’s WEEKNUM Function returns a number that indicates where that particular week falls numerically within a year. The format for this …

## How to Send an Email From Excel

Excel has a built in function that allows you to link to other worksheets, workbooks, websites and for this example also send an email by clicking on a link. …

## Select a Random Name from List of Names

It is very easy to get Excel to pick a name at random from a list of names. This is great for running competitions!! To randomly select a name simply type the …

## How to Generate a Random Number in Excel

A great function in excel is to randomly generate a number.  You may think it would require some programming in VBA but it really doesn’t.  Generating …

## Rank a List in Excel using RANK Function

If you have a list of say people with different scores, or perhaps even commission amounts, you can use the RANK function in Excel to quickly show who has …

## Get Average Number from Range of Cells in Excel

A quick way to get an average from a range of cells, instead of using =AVERAGE function, is to use the auto average button in excel.  All you do is click in …

## Summing Cells in Range using SUM Function

Before Excel 2007 the maximum number of rows per worksheet was 65000!  And if you had numbers in just a thousand of those, and needed to a total of all the …

## Counting Cells in a Range using Count Function

When using Excel, it’s often beneficial to know how many cells that contain data there are in a range.  A real easy to work this out is using the COUNT …

## Nested IF Function in Excel

Hopefully you have come to this post after reading my previous article about using IF functions in Excel.  This is a next step to using IF in Excel.  …

## Writing IF Statements in Excel

The IF Statement in Excel is a good tool, but is quite often little understood by Excel users.  The IF statement tests a value and then says whether it is …

## Using MID Function to Extract Characters from Middle of String

The MID function in Excel allows you to extract a set number of characters from the middle of a string.  For example you may have in cell A1 …

## Using LEFT Function to Select set Number of Characters from String

The LEFT function is excel allows you to extract a set number of characters from the left hand side of a string.   For example you may have in cell A1 …

## Using RIGHT Function to Select set Number of Characters

The RIGHT function in excel allows you to extract a set number of characters from the right hand side of a string.   For example you may have in cell A1 …

## How to Concatenate in Excel using LEFT, MID and RIGHT String Functions

I have worked with data downloads from companies where the date comes out of the database it is in an unsable format for date purposes.  Instead of displaying …

## How to Use SumProduct in Excel

The SumProduct feature in Excel is, I think, a fantastic formula that is so often under used.  It allows you to multiply corresponding values in your chosen …