The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
1answer
49 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
21 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
23 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
26 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
158 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
50 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
21 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
0answers
198 views

Select item from drop down menu and run macro

I have a drop down list in a sheet called 'Report', cell B9. The source for this list is in another sheet in the same workbook, 'List' with range 'A1:A32'. When the different items in this list are ...
0
votes
1answer
202 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
1answer
458 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
285 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
40 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 ...
1
vote
1answer
885 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 ...
1
vote
1answer
88 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
139 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. ...
-4
votes
2answers
825 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
0answers
320 views

pgAdmin III - how to insert data into table

How can I insert the result of some function (e.g. point(0,0) or localtimestamp) into some cell in the edit data window of pgAdmin? I keep getting an error Invalid input syntax for type ...
1
vote
2answers
343 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 ...
0
votes
2answers
1k 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
21 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
6k 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
3k 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
1
vote
3answers
86 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
124 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
451 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
264 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
646 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
300 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 ...
0
votes
2answers
170 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 ...
1
vote
1answer
61 views

Enforce style of named list items in Excel 2010

I have a named list with some values which have their own style (e.g. different colors): However when I apply that list as a data validation and select some values, the styling disappears: : How ...
1
vote
0answers
334 views

Excel Data Validation with multiple choices and free text

I have created a Data Validation list, and I have added the VB code (below) to allow the user to select more than one of the choices in the list. The user can choose from the list or enter data (if ...
1
vote
1answer
701 views

How do I make a Data Validation drop-down exclude blanks?

Related: How can I use non-adjacent cells on another sheet for a Data Validation drop-down, and only show non-blank values? For now, I've worked around the above problem by re-arranging my sheet so ...
0
votes
1answer
656 views

How can I use non-adjacent cells on another sheet for a Data Validation drop-down, and only show non-blank values?

I have a few, non-adjacent cells on one sheet which I want to use as a Source for Data Validation in a cell on another sheet. However, it seems Data Validation doesn't natively permit this. So, I ...
3
votes
2answers
1k views

How do I create a data validation list WITHOUT using cells?

I have a simple data validation dropdown that I'm trying to do, but I DO NOT WANT to use cells to populate my list. Something similar to what's below, but this obviously isn't working. What ...
-2
votes
2answers
846 views

How to check data with SHA1?

In this answer's last paragraph, Michael K. says: If you do go the multiple storage media route, too, remember to keep checking each for signs of degredation. It's fairly quick and easy to do a ...
3
votes
2answers
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: ...
0
votes
2answers
258 views

Restricting symbols allowed in cells of Excel spreadsheet

I need to format some Excel cells to allow currency (decimal point) only to be entered. Some employees completing the form enter a colon (:) instead of a decimal point which then results in an ...
0
votes
1answer
76 views

excel: the name but not the contents of a named range is the only option shown in drop down list

I have a sheet 'orders' and a sheet 'lists.' In lists, I have a list of valid fruits: a1: fruits a2: apple a3: orange a4: someone may add something here at any time I have a named range ...
2
votes
1answer
558 views

Microsoft Excel validation based on adjacent cell

I have a two adjacent columns named Country and Rating. The Country column has a dropdown to select which country a DVD is being delivered to. It is using a list validation to create the dropdown: ...
2
votes
1answer
7k 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
3answers
996 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 ...
8
votes
4answers
39k views

How to search for newline or linebreak characters in Excel?

I've imported some data into Excel (from a text file) and it contains some sort of newline characters. It looks like this initially: If I hit F2 (to edit) then Enter (to save changes) on each of the ...
0
votes
2answers
50 views

Is there a way to verify that data files are not corrupted after reformatting?

Hi all I have a C: and D: drive on one single physical hard disk, whereby windows is installed on C: and data is stored on D: After reformatting my computer, how do i verify if after reinstalling ...
4
votes
1answer
205 views

Is there any way to embed tables from excel that have pull down menu

I may not be using the correct terminoloby, but, here goes. We have setup an Excel spreadsheet that is formatted into multiple 8.5 x 11 pages on one tab. The spread sheet has tables with a pull down ...
1
vote
1answer
3k views

Conditional Data Validation

I've been taking a certification course on Excel. It's a beginner class but something caught my attention. Specifically, Data validation. We learned how to do it using the default conditions but I ...
0
votes
2answers
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 ...
2
votes
1answer
2k views

Need to recover data from a poorly burnt 8.5GB dual-layer DVD - Cannot copy half the data from the disc

Synopsis: I had a series of backup CDs that I had burnt some time ago. In order to consolidate the many discs I copied them all to my hard drive in separate folders, compressed them into .RARs (at ...
9
votes
1answer
3k 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 ...
3
votes
1answer
230 views

Best way to visualize graph on a text console?

I looking for a solution to visualize a graph on a standard unix text console. Speaking more precisely I need to visualize a graph of dependencies between files from specified set, those dependencies ...
5
votes
2answers
6k views

How do I force a user to use a specific format when entering time data?

I need to ensure the users of a particular spreadsheet are entering the time data in military time. I'm finding some folks are omitting the colon, and it's causing problems. Is there a way to force ...