Questions tagged [data-validation]
The data-validation tag has no usage guidance.
193
questions
1
vote
1
answer
20
views
Running a tool on the body of your Outlook Emails to validate them before sending them?
By default Outlook checks to make sure you have a subject header on your emails.
If you have some other non-specific external tool you wish to run on the body text of an email before sending it, is ...
1
vote
0
answers
9
views
How create increment column in visidata from a set value, not for 1?
If I have I frame with 10 rows, and I create a new column with za and then use gi I get a range column from 1 to 10, but instead of that I want to get a range column from 15 to 25.
How can I get that?
0
votes
0
answers
27
views
Excel data validation rules don't follow sorting
I am developing a program which creates a Excel file which uses data validation rules for drop-down list. My excel looks like the following pictures. Each cell has a different drop-down list.
But I ...
0
votes
0
answers
52
views
Excel for Web Data Validation List Not Working with FILTER() function
I am using a combination of a data validation list - which contains zip codes - and the =FILTER() function to try and create a drop down list of zip codes for the user to search from.
When I remove ...
0
votes
0
answers
44
views
Is a self healing triple redundancy RAID array existent?
Data gets corrupted over time caused by heat and radiation.
On a RAID 1 array with 2 drives, with two identical files (with the exception of one shifted bit), one can not know which drive is correct. ...
0
votes
1
answer
105
views
How does one embed license (or other) information into a PNG file?
I want to preface this by saying no, I don't mean steganography. What I'm looking for isn't simply putting text etc. into an image file through things like Outguess or OpenStego.
A software company ...
0
votes
1
answer
75
views
Excel Data Validation List not visible
I am trying to make a dynamic calendar in Excel 2018 for myself through watching YouTube video tutorial. But I am constantly having a problem with "Data Validation" not displaying the list. ...
0
votes
0
answers
24
views
Data Validation cells referenced changed after Data is refreshed
I created a scorecard in excel that imports data for a data source. A dropdown list is on created of different employee names through Data Validation from this imported data. Most days everything is ...
0
votes
0
answers
46
views
Depedent Filtering
Setting up a Product Order Form in excel for basic users
There is a comprehensive product master data sheet that includes product range, supplier, categories etc. This will be hidden from end user ...
0
votes
0
answers
88
views
How to apply Text cell format permanently on a google sheet's column?
I recently added IDs as Number in a column those are basically built as alphanumeric.
Then I've applied Text cell format on those IDs to keep their data consistent with the other cells in that column, ...
1
vote
1
answer
36
views
Get a drop-down list from another sheet based on lookup
I have a list of CA in my Source sheet that looks like this:
And in my main sheet I need to get a dropdown list of "little a" for each CA, like this:
Main sheet:
Sheets:
For example: ...
0
votes
1
answer
17
views
A pdf field became mandatory is there way to clean it
I downloaded a governmental pdf form and accidentally filled an irrelevant field. Now the filed field became mandatory, and pdf does not pass validation (it has a special 'validate' button).
Obviously ...
1
vote
1
answer
39
views
Excel 2019 data validation list valid formula
I am trying to create a formula for a drop down list based on a conditional format, where only the cells in G column will be shown if in the column before (the F one) in the same row the cell has some ...
0
votes
0
answers
54
views
TEXT EDITING for data processing
I have a question about text editing I have a big text file that contain input list in it as you see the example of that file on the picture. the list look like this:
Input
form
jalan
ba-jalan
pem-...
0
votes
0
answers
50
views
Excel drop down disappeares after deleting rows
I have created a drop down using data validation list. The issue is that when I delete rows the drop down in my cells also gets deleted. Is there any way tor retain the drop down ? I delete rows ...
0
votes
1
answer
79
views
Access deleted several records when data type changed. How to find which ones caused the errors?
I'm trying to work with an old Access database. It has a column formatted as Short Text that I need to change to numerical data.
To attempt to change the data type, I opened the Design View and ...
1
vote
1
answer
112
views
Can I propose a dataset from copyrighted images?
I would like to use copyrighted images to analyse an AI model I am building. Images are used for non-commercial research/educational only.
I intend to make the dataset publicly available via URL links ...
0
votes
1
answer
103
views
Limit in excel data validation source code
I have an excel file with two sheets. The second sheet (Report) contains data validation cells based on the first sheet (Data). From the second sheet, the drop-down list that displays in the Select ...
0
votes
1
answer
43
views
Sorting between start and end times for a set of projects
I need a way to nest projects that I am working on. The list is so large that it is impossible to do it by hand. I am attaching an example of what I am looking to do.
My starting data is what you see ...
0
votes
1
answer
646
views
Excel Data Validation- Numbers only and specific text
I am trying to use data validation in excel to allow a user to only input a number within a specific cell, otherwise, they can also type "unknown" within the same cell. Right now I'm using ...
0
votes
1
answer
62
views
How to Update Occurrences in a List of Excel
I am trying to build a tool tracking application where users can check in/check out tools at the required quantity. So far I have written the code for the check-in of tools which has Name, Date, Tool, ...
0
votes
2
answers
157
views
Check if parent row has corresponding values
I have a table in an Excel spreadsheet that has hierarchical rows:
(Hint: The data below can be copied from the EDIT-view in Stack Exchange and pasted into Excel. This method will result in proper
...
0
votes
1
answer
178
views
How to make data validation with unique formulas in Excel?
I am trying to keep the formulas of a worksheet intact, making sure that they will not be removed by a mistake. Using data validation for it.
This is what I am trying:
It works, but the cell content ...
0
votes
1
answer
124
views
Excel conditional data validation without named tables?
I created a conditional data validation for my device groups using "named tables" like in the example shown here:
Then on cell B5, I went to data validation, selected list, and added formula =...
0
votes
1
answer
489
views
How to have a sum of cells not exceed another cell?
Cell A23 get's its value from cells A19:A22.
Cell A23 cannot be higher than the number already in cell H2.
What formula would I use in data validation to accomplish this?
2
votes
1
answer
272
views
Data Validation - Two Cells Cannot Have the Same Value
Cell C2 and Cell G2 cannot both be greater than 0 at the same time.
If C2 or G2 has greater than 0 on it's own that's fine.
I have an error message set up saying these two cells cannot both, at the ...
0
votes
2
answers
75
views
Compare 2 Lists of E-mail Addresses
How can I go about performing a comparison between 2 lists of e-mail addresses? Specifically, I am looking to find what e-mail addresses are not present in one list vs the other.
0
votes
1
answer
55
views
How would I find how many rows in excel contain multiple unique values?
I have a list of all buyers in our state with their account number and the zip code they live in. I'm tasked with finding out how many buyers live in each zip code.
|Account ID|Zip |
| 13 ...
0
votes
0
answers
24
views
Excel - Drop down list that allows non-listed values
I'm looking for a way to have a drop-down list based on existing data BUT that allows me to enter values that are not included.
Let me picture the situation:
I have an evaluation form where we enter ...
1
vote
1
answer
26
views
Custom data validation
Using the custom data validation rule, is it possible to only allow values that follow the below criteria:
Length = 7
First 3 digits = "ISO"
Digits 4,5 & 6 must be numbers
I currently allow any ...
1
vote
0
answers
125
views
Excel - Manual Column(s) Beside Imported Data
In excel, how do you properly mix 'manual' data and imported data in a sheet / data range?
Requirement
For context, my particular use case is a sort of bare-bones data "triage" tool in excel.
Ideal ...
0
votes
1
answer
639
views
How can I assign a numerical value to cell that contains text?
I am trying to assign numerical values to a list of drop down values that are able to be selected via list data validation. I want to display the text, however be able to quantify my results with the ...
1
vote
2
answers
225
views
MS Excel. How to get around pivoting data that has blank placeholder columns?
I've been asked to produce a dashboard based on a data set that looks something like the screenshot below. The dates are the column headings and there are blank and placeholder columns in between each ...
1
vote
1
answer
30
views
Adding multiple validations to a cell
I'm adding some validations to a form in excel.
The rule is displayed when the cell is selected, and the cell must highlight red when it doesn't match the criteria.
This is usually fine except I ...
0
votes
2
answers
639
views
Two Different Dependent Drop Down Lists on Excel with Same Name Range
I'm hoping to achieve the following (using lists from data validation).
A1 cell dropdown menu: Paint, Replace, or Repair
- A2 cell dropdown menu: Replace, Repair
- A3 cell dropdown menu: Paint, ...
0
votes
0
answers
15
views
Data Validation - Using truth table to define list options
I have a worksheet where I would like two drop down lists, one for screw size, and one for screw length. Only certain lengths are available for each size, so I want the length drop down to read the ...
0
votes
0
answers
37
views
Excel - Force rows to follow pattern
I have an excel sheet of data which I am trying to sort so it follows a pattern (in order to automate the filling of a second sheet). The first sheet in question looks like this:
Example
So the ...
1
vote
1
answer
340
views
Pivot Table ineffectively capturing Multiple Selection Data Validated Cells
I have created a tracker which has several columns that allow multiple selection of values via data validation.
The goal is to create dashboards with slicers to analyse this data. For eg- Lets assume ...
0
votes
1
answer
14
views
Optimize code to check a Data Validation cell to pick another cell
I have cell E2 that contains a Data Validation group: "online", "article", "journal", "proceedings" and "magazine". I am populating cell K2 with a formula that is based on E2's entry. If I select an ...
0
votes
0
answers
5k
views
How To Apply Multiple Data Validation In One Cell In Excel Worksheet
I want to apply 2 conditions on a range of cells.
The first one is each cell takes value from a drop down list. I implemented this by Data Validation dialog box, selecting List option and typing the ...
0
votes
1
answer
303
views
Using data validation to list a column
I have a workbook with a table that has headers with names and group. The names column is distinct (no name is repeated) whilst the group column has values (like G1, G2, G3 etc) which are repeated.
I ...
1
vote
2
answers
850
views
Data Validation in Excel - Two Cells can't be the same
I have two columns with headers "Sending" & "Receiving" and I'm working on adding data validation layers to the spreadsheet.
The cells already also have a data validation setting allowing only a ...
0
votes
1
answer
45
views
Excel 2010 is repeating the optioned text in a data-validated cell. Is this a bug?
I have a table column that has data validation applied. It was working fine for a while, but now all of the entries are repeated – as in, if the option selected from the dropdown is "Per Diem," Excel ...
0
votes
1
answer
716
views
What are the limitations of the "Data Validation" custom formula in Excel 2010?
TL;WR Why does =if(column()=16, list1, list2) give an error when being used as a List-type Data Validation function?
The long version:
I have been hollering at my computer all afternoon because I ...
0
votes
1
answer
763
views
Data validation in Excel based on value matrix
I'm really struggeling to solve the following task. I have a data matrix where vehicles and features are matched.
Now I want to use this as source for Excels input validation feature in a second ...
0
votes
1
answer
34
views
Ordering Excel data for data validation (dependant dropdown lists)
I am having a little bit of problem with making dependant dropdown lists.
I want to Select the name of my Adventurer and then Select a skill. The skill should be valid and usable for that class.
...
0
votes
1
answer
2k
views
How can I Protect/Lock a spreadsheet but allow the use to make Validation List Selections?
I would like the user to be able to select the Validation List drop-down and make a selection but if the cell is Formatted as "Locked" and "Hidden" and Protection is turned on, as soon as the ...
17
votes
4
answers
13k
views
Which characters are invalid for an MS-DOS filename?
I'm writing a filename I/O procedure in x86-16 assembly language. It takes eight characters (I don't need to support long filenames) from the keyboard and prints them to an on-screen text input field.
...
0
votes
3
answers
2k
views
How to prevent deletion or change of referenced values in Excel?
I have an Excel sheet which contains unique IDs, and another sheet which contains entries which reference by value (via Data Validation - List) those IDs from the first sheet.
I have enabled Data ...
1
vote
1
answer
98
views
Conditional defalt on data validation list
EDIT No. 2
*Ok, my previous articulations of my problem were, as pointed out, pretty rubbish. This edit, rephrases the question in a more straightforward manner, summarises the context and provides ...