The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
24 views

Excel Combo Box — how to validate input (not data validation list)

I'm trying to use Active X Combo boxes instead of Validation Lists for some dropdown menus in Excel, because it's more apparent they are drop-down selections (arrow icon appears next to it). However ...
0
votes
1answer
21 views

Excel 2007 Custom Data Validation, Excluding characters in large range

Trying to create data validation (absolutely no macros, it is simply not an option), where a user can type in only Basic characters (A-Z,a-z,0-9,-,~,',\,/) So what I tried to do is create a ...
4
votes
1answer
69 views

Make dropdown list show hyperlinks

I have a collection of all the different part numbers for different versions of a single part, and each of them is hyperlinked to their specific different drawing in pdf form. I would like to put them ...
0
votes
1answer
39 views

Data validation to give text a value that's used in a formula elsewhere on the sheet

We have a group planning to charter a sailboat as a vacation for 10 days. I'm trying to show the total costs of the trip. It's a simple spreadsheet listing many semi-fixed costs like food, beer, ...
-1
votes
1answer
58 views

prevent duplicates in excel is easy but

We all know how to prevent duplicates in excel by using data validation and the custom formula : =COUNTIF($A:$A;A1)=1 for example. but I need to add a time condition, so every day I'm typing some ...
0
votes
2answers
113 views

Data validation in Excel- all values in comma-delimited list within cell range

I have a reference table of memos and some information about them, including what other memos they reference and are referenced by. I want to make a data validation rule that will appear red if any of ...
0
votes
1answer
41 views

How to populate a dynamic dropdown list based on a value and a table

I have a table as follows: Item Name Slot Bronze Dagger Main Hand Shortbow Off Hand Magic Staff Main Hand and so on. I want to have a drop down list somewhere ...
1
vote
0answers
42 views

Is there any way(e.g. software etc.) where data can be matched visually

I have two columns in excel(see N.B.) that contain as below Column1 Column2 ------- -------- USA India Serbia United States of America Bharat China ...
1
vote
1answer
14 views

Excel: Separate Currency Values from Rest of Line

I have the following conundrum, which I think will be helpful for a lot of people. I have been pulling down data from bank statements (yes, I could use Mint; no, I don't want to for various reasons), ...
1
vote
1answer
50 views

Cell with 2 options and I want to add a third

So I have this excel file where when I select a particular cell a little box with an upside down triangle appears to the right of the cell. When I click on this there is a small list of options to ...
1
vote
0answers
128 views

Data Validation list to add multiple item, comma seperated in the same list excel 2013

Ok, so I have a list of categories in sheet 'categories' (column A - with a header in row 1 - it goes down to row 72 - I have called this list 'categories' as well) in sheet 1 'Productlist' column D ...
3
votes
1answer
138 views

Can CPU overheating cause data corruption?

Background: I realized recently thanks to dmesg and syslog that my CPU has been overheating since May. No overclocking. I have an Intel® Core™ i5-2500K, and the stock cooler was simply defective as ...
0
votes
0answers
34 views

Excel - Conditional formatting retention through data validation in another sheet

I have applied conditional formatting in an Excel sheet (Sheet2) to change the font color in column A if the result in the adjacent cell in column B is "No." I then used this conditionally formatted ...
3
votes
1answer
341 views

Excel “Smart” Dropdown / Data Validation

In Excel, is there a way to create a dropdown menu or data validation field that Allows the user to enter a value that is not currently on the list (like a combo box) Save that value in the dropdown ...
1
vote
0answers
352 views

Dependent Drop Down lists and Data Validation; Multiple Lists

Right now, I have My goal: Add a Data Validation List into another sheet such that when I select an item from Column B, everything from Column K appears that is linked through into Column B (...
1
vote
2answers
170 views

How to use validation to make sure cell value starts with specific word

I need to check if the value of a cell starts with the term superuser. The entered value then should, for example, look like this: superuser template If the user enters super user template (with a ...
0
votes
2answers
598 views

How do you get excel to ignore zero or blank values in an Average?

I am making a spreadsheet to score recipe ingredients, averaging scores for quality of the ingredient, packaging, and accuracy of serving size, and then using that data to create an average for the ...
1
vote
2answers
756 views

How to make data shown on excel drop down list appear as numbers (shortcuts)?

Is it possible to have the data (choices) shown when clicking the drop down list to appear as numbers (or any text other than the actual text from validation data source)? Let's say the choices (drop-...
0
votes
0answers
40 views

How to validate autonumbering in MS Excel

I've made a running numbering function that autofills the numbers in every new row of my table. In most cases, I want to limit editing for this field, though sometimes I would need to keep it ...
0
votes
1answer
273 views

Drop downs dependent on each other [closed]

I have 2 lists of values: 1 Car 2 Dog 3 House 4 Hat 5 Boat Each of these is used to populate a drop down list. I am trying to allow the user to select from either 1-5 or Car-...
-1
votes
1answer
87 views

Excel data validation: restrict to 10, 20 etc

I am trying to use Data Validation in Excel 2010. How can I restrict entry into a cell to numbers divisible by 10?
-3
votes
1answer
64 views

I need some help in excel validation [closed]

I'm not good in excel. I need to include an excel sheet in my page, and I need an expert who can write these custom formulas for cells validation. 1) A column that accepts only letters, no numbers or ...
0
votes
1answer
94 views

Excel: How to prevent rounding off of cell in display which does not affect the data validation

I have format my cell to 3 digits with 2 decimal places. If I entered 9.999, it automatically rounds off to 10.00 on display. I cannot convert it to text for I need to put data validation on it ( ...
1
vote
1answer
82 views

how to verify TBs of data copied from cloud [closed]

First post, hope it helps someone else storing large amounts of data online. I use a cloud service, Bitcasa (NOT recommended) to serve my media library and for personal backup. They've recently ...
1
vote
0answers
153 views

Creating a list from another list's value

How can I populate a cell with a list as a result of a condition from another dropdown list? I have a dropdown list, when I select a value from it I will need to populate the cell beside it with ...
0
votes
2answers
248 views

Multiple validations in one cell

I am trying to creat a validation that says the date can only be today() + or -7 AND it can not be a weekend. I have gotten the two parts to work seperaTELY but not together. I do not seem to be ...
0
votes
1answer
3k views

Excel 2013 Data Validation List no longer works in my workbook

I am using Microsoft Office Professional 2013 with Excel 2013 on a Window 7 Enterprise Laptop. I have run into a problem that I cannot correct. I have a worksheet that I have been tracking data in ...
1
vote
1answer
5k views

How to set up data validation to allow only a date or a specific string

I would like to use data validation to ensure someone has entered a valid date, but I'd also like them to be able enter TBD - just those two options. Is this at all possible without VBA? Is there a ...
0
votes
1answer
704 views

Excel 2013 Multiple Validation Rules

I have a 2 part problem that I am having issues with... mainly part 2. I have gotten the first part to work by itself. 1) I have a column which contains part numbers (###-#####-###). I am using data ...
0
votes
1answer
39 views

Excel (Dependent) Data Validation Across three seperate fields

I am looking to create a data validation formula which will allow me to check against multiple fields. Amount Claimed, Amount Approved, Amount Paid. The Amount Claimed is first entered. From there, ...
0
votes
1answer
907 views

Use an user defined function for data validation

I created a named range which is the result of a user definer function. Let say my rage is named List and has three items, if I select three cells and enter =List and press Ctrl+Shift+Enter, I get ...
3
votes
2answers
5k views

show more than 8 items in the Data Validation drop down list in Excel

I have added a simple data validation to a cell but it only displays 8 items in the dropdown. Excluding the combobox solution and probably involving some WinAPI is there a way to make the drop ...
0
votes
1answer
3k 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
1answer
625 views

How to have a drop-down in a cell only if certain cells have text

I am trying to put a drop-down in one cell with options "Open" or "Closed." However, I don't want the user to be able to select from the drop-down unless they have entered text in cells A2:G2. I ...
3
votes
2answers
4k views

Data Validation of a Comma Delimited List

I need a simple way of taking a comma seperated list in a cell, and providing a drop down box to select one of them. For Example, the cell could contain: 24, 32, 40, 48, 56, 64 And in a further ...
2
votes
1answer
337 views

Data Validation arrow hidden from freeze panes?

I've been searching with no luck about my issue of the data validation drop-down arrow being hidden by freeze panes. I have read multiple forum posts about Excel 97 having this as a bug, but fixed in ...
0
votes
1answer
518 views

MS Word Mail Merge: Validate Data

Is it possible to implement validation rules in a Word mail merge? I want to set up the Word file so that if a given test fails, Word will take some action when attempting to complete the merge. Here'...
-4
votes
2answers
3k 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? Ex....
1
vote
2answers
931 views

Excel: Reference Dropdown Cell in Countif Formula

I'm trying to substitute text in an excel formula with a cell reference to the text in a dropdown. First formula that yields the correct answer is: =(SUM(COUNTIFS('LP - All Properties'!G:G,{"Phoenix"...
0
votes
2answers
8k views

How do I require a cell in one column to have a value if a cell in another column (same row) has a value?

I'm trying to require a value to be populated in column A if column D has an amount in it. Column A can hold any type of value (text or numerical), column D can only be a number. So, for example, if ...
2
votes
0answers
23 views

Policy consolidation by Account

Objective: I need to find a way to consolidate multiple home and auto insurance policies purchased by an Insured (aka, policy holder) and assign those policies to a single customer account for that ...
1
vote
1answer
18k 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
1answer
9k views

Excel data validation to whole column

I want apply data validation list to a whole column in excel 2010. How can I do that with out copying the validation rule
2
votes
3answers
104 views

How can I avoid typing in a value which already exists in another range in Excel 2010?

I am working up a basic project tracking spreadsheet in Excel and would like to have two sheets - one which shows my active projects and one which shows my completed/cancelled/archived projects. I ...
0
votes
2answers
168 views

Error proofing data

Is it possible to encode data is such a way that it can self-recover from corruptions? (corruptions - for example, hard drive or usb drive with bad sectors) I'm not looking for solutions involving ...
2
votes
1answer
1k views

Enforcing format input into a cell

I need my spreadsheet to only allow users to input in the format hh.mm/hh.mm for their working pattern e.g. someone works 12.5 hours in a 37 hour week would only be allowed to be input as 12.50/37.00
1
vote
0answers
361 views

Remove corrupted files

For some mysterious reason, my computer formatted my 'Data' drive while I was running Windows 7. I managed to recover a large amount of the data to another drive using Test Disk in Ubuntu. Because the ...
1
vote
2answers
1k views

MS Excel data validator does not accept call to the custom macro

I have the working VB macro that validates the content. It takes two string parameters (cell value and regular expression) and returns either True or False. It uses CreateObject("VBscript.regexp") ...
0
votes
1answer
463 views

Can I force MS Excel table column to use the specified pattern?

I need to develop a tool that enforces strict format of some table. The fields in this table follow specified patterns like number:number (11:20. 2:00), agreed date (11/20/2012 but not locale-...
0
votes
2answers
210 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 ...