# Tagged Questions

**0**

votes

**1**answer

77 views

### Microsoft Excel 2007 - Drop down list that grabs multiple columns from another sheet

I've been scouring the internet for this but can't seem to find a solution.
Let's say I have 2 Sheets - "Items" and "Inventory".
Inside "Items", I have 3 columns:
Item Name
Item Type
Item Cost
...

**1**

vote

**1**answer

4k views

### Linking dropdown lists

I would want to link a drop-down list to the values of an adjacent cell. Let say, we have two cells A2 and B2. A2 is a drop-down list with values: Agric, school, sme and housing, while B2, which is ...

**0**

votes

**2**answers

158 views

### Filter Duplicates by count of a character Excel 2007

I have a data list of around 32000 items in column A. Each of these items has many duplicates, some having 1 duplicate, up to about 5 or so max. Each cell has multiple sku's, divided by a /.
What I ...

**3**

votes

**2**answers

1k views

### Excel Conditional Formatting

Highlight all non-blank entries in a column, except for the column header, that do no fall in some range.
Here's my attempt:
...

**2**

votes

**1**answer

6k views

### Excel 2007 Data Validation: Validate Against List or Allow User to Enter Custom Value

I know this kind of defeats the purpose, but is it possible to have an Excel 2007 spreadsheet with a cell that has:
Validate against a list that is column in the spreadsheet.
If not in that list, ...

**0**

votes

**3**answers

851 views

### Table data entry - How to always have a blank row at the end of an Excel table

I'm creating a simple Excel spreadsheet for table data entry (table created using the "Format as table" option -- couple of columns, there could be hundred of rows). I would like to always have the ...

**0**

votes

**2**answers

1k views

### Excel 2007 vs Excel 2010: Data Validation values using Named Ranges and the INDIRECT function

I am running into a bizarre error in Excel that I am hoping someone can help me with.
I have a macro-enabled workbook created in excel 2010. On the workbook are a series of radio buttons. When a ...

**9**

votes

**1**answer

2k views

### Setting a default value for a dynamic cascading validation list in Excel 2010

I have finally figured out how to build a dynamic cascading set of lists in Excel using Data Validation and the INDIRECT function. However, I'm running into a problem.
I would like to set up my ...

**4**

votes

**2**answers

315 views

### Entering only Digits in Excel DataSheet Cell

I want users to enter only 1 or 0 in a cell column in Excel 2007. Users should not be able to enter anything else than 1 or 0. How can I do this in Excel?

**1**

vote

**2**answers

1k views

### How do I prevent users from entering a blank value in an Excel sheet?

I want to restrict users to entering either just 0 or 1 in an Excel 2007 sheet.
I use the Data > Data Validation dialog to do this, but I'm finding that it doesn't stop them from entering blanks.
...

**4**

votes

**1**answer

4k views

### Custom Validation - Dependent Drop Down Lists

I've two columns in a sheet that are interdependent and I want to use validation, drop-down lists, on both as follows:
Column A (TYPE) | Column B (Sub-TYPE)
...

**0**

votes

**1**answer

94 views

### How do I ensure only integers and with no duplicated values can appear in a column in Excel 2007?

How do I ensure
only integers
with no duplicated values
can appear in a column in Excel 2007?

**1**

vote

**4**answers

3k views

### How to input only unique values in a column in Excel 2007

I'd like to know the easiest way to make sure that only unique strings are entered in a particular column in MS Excel 2007? I know I have to put a formula in the Data > Data Validation, but I don't ...