# Tagged Questions

**0**

votes

**2**answers

38 views

### How to sort columns in Excel so that only one value appears in each row?

Say I have a a spreadsheet with the following data:
A B C D
---------------------
2 1 0 2
3 2 1 4
5 3 3 6
7 5 6 8
11 8 10 10
...

**-4**

votes

**2**answers

206 views

### Custom Data Validation in Excel 2010 [closed]

I'm trying to make error messages appear when someone tries to enter the wrong data type in a certain cell with data validation in Excel 2010. Is there a feature or some sort of formula I can use?
...

**0**

votes

**1**answer

40 views

### Excel/Calc: Pivot table with (almost) identical row: how to identify them?

I need to examine via pivot a datasource from a sheet. This datasource sheet is something like this:
| Field 1 | Field 1 | Field 3 |
| AAAA | BBBB | CCCC |
| DDDD | EEEE | FFFF |
| GGGG ...

**1**

vote

**1**answer

723 views

### Filtering by currency in Excel

I have this situation in Microsoft Excel:
Cells are formatted by using "Format Cells" and setting the Currency manually for each cell. So, they are not simple strings. I would to sum filtering by ...

**2**

votes

**3**answers

14k views

### Excel: Multiple =IF calculations within one cell

I need to do some text comparisons in excel, about 20-50 of them. I would like the result of these if statements to be within a single cell. Here is how I WISHED it would work:
...

**0**

votes

**3**answers

3k views

### How do I add content to Excel cells?

How can I add a T to the content of each cell in a certain column (that contains 10000 cells) without typing it manually?

**0**

votes

**1**answer

2k views

### Microsoft Excel Exercises for learning purposes

I'm not sure if it belongs this here, but if you feel it doesn't just please remove it. I'm looking for a good source of exercises in excel that is good in teaching a friend of mine that wants to ...

**2**

votes

**1**answer

167 views

### Conditional Formatting in Excel

I have a worksheet with a series of rows A1 - H1 etc and a drop down list which lives in H1, I would really like to change the cell styles of all the cells between A1 - H1 based on the value in H1.
...

**13**

votes

**2**answers

5k views

### Excel Conditional Formatting Escaping a Question Mark

I would like to use a conditional formatting rule in an excel file that would color any box with a question mark in it red. It seems that Excel is using a question mark as a wild card and will turn ...

**3**

votes

**3**answers

4k views

### Excel annoyance: How to maintain formulas in a ledger?

A common use of Excel is to create a spreadsheet which functions as a transaction ledger of some kind, where one or more fields in each row is calculated by adding a value or values from the current ...

**1**

vote

**3**answers

2k views

### How can I use the Excel PMT function to calculate a mortgage payment?

The formula wizard asks for:
Rate, NPER, PV, and FV.
I have the following info:
I guess the rate would be the annual interest rate (say 5.5%) divided by 12, or 0.48%.
NPER is the number of ...

**3**

votes

**4**answers

3k views

### How can I copy a formula multiple times and always refer to the same cell?

I have a number in cell A1 and a column of 20 numbers in the B column.
I'd like to put a formula in each of the cells in the C column next to each number in the B column. Let's say it's =B1-A1, and ...