Questions tagged [data-validation]
The data-validation tag has no usage guidance.
207
questions
1
vote
1
answer
91
views
Excel spreadsheet with multi-select column and data validation
I am creating an Excel spreadsheet with 3 columns: category, subcategory and description.
Category and subcategory will both have dropdowns. I have already added this by using name ranges and data ...
- 11
0
votes
1
answer
174
views
Data validation using a list that depends on another cell
I have an Excel file similar to this:
I would like to create a data validation using a dropdown for the cells E2, F2, G2. I would like the user to insert only the values available in $B2:$B5 filtered ...
- 101
0
votes
1
answer
159
views
How to filter Excel list using data validation lists and matrix
I have a table of document names in the first column, and users in the following columns. I'm using the rows beneath each user to assign them documents to review. The list is quite long and I'd like ...
- 3
0
votes
1
answer
106
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. ...
- 191
0
votes
1
answer
371
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 ...
- 1
0
votes
0
answers
621
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
536
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:
...
- 178
1
vote
0
answers
259
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&...
- 111
2
votes
1
answer
92
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
383
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 ...
- 11
0
votes
0
answers
809
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 ...
- 1
0
votes
1
answer
249
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 ...
- 203
0
votes
1
answer
275
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 ...
- 101
1
vote
0
answers
160
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 ...
- 11
0
votes
0
answers
136
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 ...
- 1
0
votes
0
answers
516
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
1
vote
1
answer
538
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 ...
- 22.9k
1
vote
0
answers
65
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?
- 11
0
votes
0
answers
348
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 ...
- 101
0
votes
0
answers
346
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 ...
- 13
1
vote
1
answer
826
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 ...
- 184
1
vote
1
answer
426
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. ...
- 11
0
votes
0
answers
52
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 ...
- 1
0
votes
0
answers
838
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, ...
- 31
1
vote
1
answer
72
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: ...
- 13
0
votes
1
answer
30
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 ...
- 156
1
vote
1
answer
114
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 ...
- 13
0
votes
0
answers
61
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-...
- 1
0
votes
0
answers
390
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 ...
- 19
0
votes
1
answer
384
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 ...
- 317
1
vote
1
answer
331
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 ...
- 15
0
votes
1
answer
199
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 ...
- 81
0
votes
1
answer
46
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 ...
- 17
0
votes
1
answer
3k
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 ...
user1193391
0
votes
1
answer
83
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
279
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
...
- 167
0
votes
1
answer
317
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 ...
- 101
0
votes
1
answer
337
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 =...
- 13
0
votes
1
answer
2k
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?
user1151900
2
votes
1
answer
839
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 ...
user1151619
0
votes
2
answers
270
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.
- 201
0
votes
1
answer
61
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 ...
- 3
0
votes
0
answers
127
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
71
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 ...
- 7,505
1
vote
0
answers
191
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 ...
- 11
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
1
vote
2
answers
714
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 ...
- 51
1
vote
1
answer
35
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 ...
- 13
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, ...
- 3
0
votes
0
answers
60
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 ...
