The tag has no wiki summary.

learn more… | top users | synonyms

1
vote
2answers
935 views

software tools for cleaning up messy data (flat files, Excel etc) semi-automatically?

I routinely receive files, usually Excel spreadsheets, which contain manually-entered data that have outgrown the utility of spreadsheets. I then clean up these files for import into a database. ...
0
votes
1answer
93 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
4answers
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 ...
0
votes
1answer
676 views

Using Excel Lookup Function and Handling Case Where No Matches Exist

I'm using Excel to enter data for an event where people register. A high percentage of the registrants will have registered for previous events, so we can their name and ID number. I'm trying to use ...
6
votes
3answers
2k views

Excel: Update a value in a named range

I've got some cells in an Excel doc populated from a named range (data/validation/list source=MyNamedRange): Here, the A1:A3 range is named Foobar B5:B6 is under data validation with it's source ...
4
votes
3answers
554 views

Email address validation tool - recommendations/experience?

I recently came across a tool which will take a list of email addresses, and attempt to cleanse it of the nonsense addresses that people use when wanting to download/sign up for something without ...
8
votes
1answer
940 views

Where is data validation text stored in Excel?

I have an Excel 2003 sheet with lots of different data validation rules. Is there anyway that they can be viewed other than through the regular data validation dialog? It would be helpful to export ...
5
votes
1answer
2k views

Excel, drop down lists

When I created custom drop down lists in excel, my excel sheets don't trim down to a smaller list when I start typing in the drop down list cell. For example if my drop down list is for USA States ...
0
votes
1answer
218 views

Statically Display Excel drop-down boxes

I'm looking to present an Excel questionnaire I have written to the board, via either paper or presentation slides. It uses a lot of drop-down boxes, and so I'm looking for any ideas on how one might ...
2
votes
2answers
828 views

In-cell Validation Drop-down list - widen

I have quite a few cells with Data Validation with options in the list that are long strings. Short of widening the column, is there any way to widen the drop-down list so that the user can see the ...
2
votes
2answers
8k views

Unlocking Locked Drop Down boxes in Excel

I have a couple of drop down boxes on a form that are what I'd like to dub "perma-locked". Every person we've thrown at the form is unable to unlock the drop down. The drop downs do not show a ...
3
votes
1answer
6k views

Multi-value selection in an Excel cell

There's a way to make an Excel cell kind of a dropdown selection box. You would just go to Data->Validation with a cell or a range of cell selected, select list as the data type and specify the list ...
2
votes
1answer
594 views

Excel validation - can it be used to make sure duplicates are not entered?

I have an excel spreadsheet - is it possible to have validation so that a column cannot contain a value that already exists in the column?