QUESTION : When the user launches Excel 2010, it will open five or six windows of excel macros. I know […]

# Category: Ms-Excel

## Excel COUNTIFS with multiple criteria

QUESTION : I would like to use a COUNTIF formula with two criteria. This is the formula I have now. […]

## Excel COUNTIF Not Working

QUESTION : I got a column with several rows containing m or w. So I just want to count how […]

## How can I return the contents of cell(s) that occur in two cell ranges (concatenating if multiple matches occur)?

QUESTION : I have the following spreadsheet and need to be able to check if a cell (or multiple cells) […]

## How to sum and display time in day-hr-min format

QUESTION : Lets say I want to display O9 in day-hr-min format by adding 08 to I9,J9,K9 ANSWER : You […]

## excel equation to find corresponding value

QUESTION : I hope if some body can help me with this, i tried many search over last week but […]

## Changing font colour in a cell with a formula

QUESTION : I have a spreadsheet that is used by a group of people. Its purpose is for service admin […]

## Excel 2013 – Pivot Table

QUESTION : I have a large data set with five columns: Name of employee Total revenue generated by employee Total […]

## Excel – Multiplying daily values for each week

QUESTION : What I have: over 200 rows, each with three values, each for a unique day. Only values for […]

## Comparing Four Columns in Excel

QUESTION : I have two lists in a spreadsheet. Both lists consist of two columns. One column is computer serial […]