Questions tagged [data-validation]
The data-validation tag has no usage guidance.
206
questions
0
votes
1
answer
53
views
Is it possible to turn off certain Excel functions related to conditional formatting and data validations?
I have come across a monstrosity of an Excel, while it does not make any sense in my opinion to have this Excel. Some of my colleagues at this large corporate are extremely fond of using it. ...
0
votes
1
answer
74
views
Would a badblocks read-only test be sufficient to verify data integrity/drive health? (Badblocks/Linux)
As the title suggests I have a HDD which I haven't powered on for the last year or so and I wanted to check for bad sectors. Usually I do a destructive 4 pass read-write test with badblocks to test ...
0
votes
0
answers
126
views
Data validation list doesn't auto populate with new row
I'm at a loss with the data validation lists in my table. I am using the form field to enter new values into my table. Using this method the new row does apply to the table but not all of my data ...
0
votes
1
answer
102
views
Error trying to create dropdown list validation from defined name in Excel
I'm trying to create a data validation dropdown list from a defined name in Excel. It works fine on most sheets in the workbook and in a new sheet. But in one sheet where I need it I get the error:
...
1
vote
0
answers
114
views
Excel VBA Data Validation to check if data validation in the table has failed
My below code does two things wrong.
First, it checks for data validation for all the cells in the sheet even if those cells are outside the DataBodyRange of the table and shows MsgBox "Failed&...
0
votes
0
answers
81
views
Prevent VBA from duplicating dropdown list selections when entering manual text
I'm using a VBA code for a dropdown list with multiple options in Excel, but when I enter text manually in a cell that already contains one or more selected options, the code duplicates the previous ...
0
votes
0
answers
33
views
Excel is auto-changing case entry in data validated cells
Problem: For cells which have data validation: Users type a capital 'A' in a cell and Excel is changing the letter to lower case 'a' to match the validation cell value. This is a brand new behavior, ...
2
votes
1
answer
59
views
Copy text into Excel, Fixed Width, where data starts every 40 rows
I have data from a text file I want to import into Excel. The text data is grouped in blocks of 40 rows with headings. After about 12 rows the new set of data starts again with headings. There are ...
1
vote
1
answer
177
views
How to display Excel table (data validation list) based on the value in previous cell- multiple tables
I have multiple tables with various data that is related to each other in Excel (example here: Tables in Excel)
I have named all the tables (example here: Tables' names)
And I have created lists from ...
0
votes
0
answers
380
views
Auto Update list output in Excel
I have an Excel sheet which uses a drop down list. When I update an item of this list (so I'm not adding anything, I'm just changing the name of the item that was already in the list) the old value ...
0
votes
1
answer
66
views
How to allow user to enter data in the fields in a Table but keep data validation rules on that field hidden?
I am preparing a tracker in MS Excel. The tracker will be used by multiple users across the organization on different PCs. So, I will not have control over what they will do with the excel.
In order ...
0
votes
1
answer
103
views
Is the following IPv6 address valid?
i'am asking for a friend. Really :-)
Given the exam question:
Is the following IPv6 address valid?
2001:0DDB8:0:0:8:800:200C:417A
RFC4291: Text Representation of Addresses
I say no since the second ...
0
votes
0
answers
64
views
Have drop down list for column show one value but input another
What I’m looking to do is have a column in sheet A where each cell has a drop down list. The values of that drop down list are in column 1 on sheet B, but when you select a value, it actually inputs ...
0
votes
0
answers
84
views
How do you generate a list on excel based on complex criteria when the data set is not unique?
I am trying to build a excel sheet that automatically generates the list based on the 3 criteria (each criteria has a dropdown). Below is the template I created.
Criteria list:
Purpose, loan type and ...
0
votes
0
answers
241
views
Excel Data Validation: If any cell in this row isn't blank there must be a value in this cell
I'm trying to set up data validation in a cell so that if any cell in a range in that row has a non-blank cell, the cell with the validation must have a value from its drop-down list. As data is ...
1
vote
1
answer
418
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
52
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
200
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
268
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 ...
1
vote
1
answer
527
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
342
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
49
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
565
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
56
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
29
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
79
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
60
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
225
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
270
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
218
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
177
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
45
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
2k
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
72
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
258
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
285
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
220
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
1k
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
647
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
167
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
56
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
42
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
57
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
164
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
1k
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
454
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
33
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
1k
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
31
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
43
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 ...