# Tagged Questions

**0**

votes

**2**answers

26 views

### Excel: Applying Condittional formatting to every other row

I would like to apply a specific conditional format to every second row in my spreadsheet. In my specific case I have regression results, where the first row indicates the beta coefficient and the ...

**0**

votes

**1**answer

47 views

### Generate ordered numeric list in Excel based on cell value

I'm not sure if this is possible, but I would like to create an ordered numeric list automatically based on a cell value. For example, if I have a cell with a value of 100, I want excel to ...

**1**

vote

**1**answer

130 views

### Displaying Other Values Via COUNTIF in Excel

Basically I have a sheet like this:
A B C D
Name (From File 1) Name (From File 2) Phone Number Countif
Walt ...

**0**

votes

**0**answers

64 views

### Update Excel table with newest available information and put old information on separate sheet

I have combined several worksheets into one master spreadsheet. Unfortunately, each spreadsheet parts of the original spreadsheets had complete information. I need to clean up my information. What I ...

**0**

votes

**2**answers

320 views

### If / Else logic involving text i Excel

I want to perform the following logic in a Microsoft Excel 2010 worksheet:
In cell E3: if C3 = Off or off then VALUE=0, else Value=C3*D3
Where cell C3 will contain either a number or the word 'off' ...

**1**

vote

**3**answers

8k views

### Microsoft-excel newlines and tab

Current I use "CONCATENATE" to join string in Excel, but I want insert character newlines and tab in string joined by "CONCATENATE".
Example:
I've string below when I completed join string.
"Today ...

**0**

votes

**1**answer

308 views

### Comparing two Excel Work sheets for re-used/non existing names

I have two excel worksheets that I need to find names that do not appear on one to the other. They are both very similar, however because of the added names a quick If true/false function will not ...

**2**

votes

**3**answers

193 views

### Getting the value in one column from a formula on another column in excel

I have an excel table that looks like this:
Date Original Actual
11/10/10 15 12
12/10/10 12 10
...
24/10/10 2 1
25/10/10 -2 ...

**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 ...

**4**

votes

**2**answers

901 views

### How can I create a reusable function in Excel 2007?

How can I create a resuable function/formula I can use in formulas in a spreadsheet? In particular I need a very simple DateDiff formula and would like a way to encapsulate this function:
...