Questions tagged [data-validation]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
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 ...
user avatar
  • 19.8k
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?
user avatar
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 ...
user avatar
  • 101
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 ...
user avatar
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. ...
user avatar
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 ...
user avatar
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. ...
user avatar
  • 1
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 ...
user avatar
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 ...
user avatar
  • 1
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, ...
user avatar
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: ...
user avatar
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 ...
user avatar
  • 129
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 ...
user avatar
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-...
user avatar
  • 1
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 15
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 ...
user avatar
  • 71
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 ...
user avatar
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 ...
user avatar
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, ...
user avatar
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 ...
user avatar
  • 105
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 ...
user avatar
  • 101
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 =...
user avatar
  • 13
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?
user avatar
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 ...
user avatar
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.
user avatar
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 ...
user avatar
  • 3
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 ...
user avatar
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 ...
user avatar
  • 7,196
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 ...
user avatar
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 ...
user avatar
  • 1
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 ...
user avatar
  • 51
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 ...
user avatar
  • 13
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, ...
user avatar
  • 3
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 125
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 ...
user avatar
  • 409
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 ...
user avatar
  • 103
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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. ...
user avatar
  • 103
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 ...
user avatar
  • 1
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. ...
user avatar
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 ...
user avatar
  • 1,755
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 ...
user avatar
  • 121