data vaidation

Hey I need help on this: I first solved the proplem of showing the correct cities based on the what was selected in the first drop menu by using this formulas in data validation: (coutry and city are named ranges for countries and cities). IF($E$3="US",OFFSET(city, 0, 0, 2, 1),city) But the...

Hi I am hoping someone will know this. I have a data validation list for a change of a product outside of the generic product, meaning I want the first item on the list to be a = to the main generic product (which changes to other products on the list) and the rest of the items are all the...

Hi, I've been trying for a while to figure out a way to use data validation and/or conditional formatting when entering Swedish social security numbers (personal id-number) to check that the value is valid but can't get my head around it. I found an old thread on a forum that has been shut...

Hi there, new to the site and I really need some help. I've tried by my self (and with online resources) with no luck. I have a file called online class registration. The first sheet is called DATA and, every Monday, I will paste into it data from a static excel report from a MS Form. The data...

Hello, I have an excel sheet I use for a golf leage that I run, I made some changes to the list of team this year copying and pasting into a few of the teams lists which seems to have broken some links. I don't jhave any contact with the person who helped me creat this initally, and due to an...

Hello, Could somebody help? I have data in Sheet 'Reference' as per below: A B 1 Category1 Category2 2 Cat1.1 Cat2.1 3 Cat1.2 Cat2.2 An in the other sheet named "Data Input", in column B for option i should have a drop-down refering a data in sheet 'reference' and the...

Hello, trying to get a data validation, or more specifically, a warning message (and a stop message) based on another cells value once the check box is selected. The only way it will work is if the cell is edited, which is how data validation works but I'm trying to automate, VBA would be useful...

Hopefully I’m not overthinking this. Here’s was I have. (I’ll upload a mini-sheet in a few. I have a data table that is 15 or so columns long but has about 2k rows of data. Export sheet (sheet1) Column A is my salesperson Name Column d is cust service rep. Column N is the name of the...

Hey All, I have created data validation fields in several worksheets. When using them in Excel Online, I used to be able to start typing and have an auto filtered list popup based on what I had input to that point. Suddenly, this autofill feature is no longer there. Is anyone else having this...

Hi! I am having a difficult time figuring if I need a VBA for this as I have a source or list with all the items and each cell, I want to select some of the items into a drop down list is that possible? Thank you.

Hello! I'm extremely new to all of this and I am trying to create a drop down menu that will allow me to make multiple selections plus show any results that contain the selected option in any way. D12Order3Urine culture4Urine culture5Urine culture6Throat Culture7Throat Culture8HIV screen, RPR...

I started with a Data Validation Drop Down List in cell N1 that used the column "Symbol" which is the first column in a table named "StockData" in a worksheet named "Stock Data". The column is a Stock data type. It worked great, but there were 81 Stock Issues listed, and I wanted to be able to...

Hi all, I have a dropdown list on column AY with 'In-Scope' & 'Removed' as the options. If a user selects 'Removed' I wanted to force them to enter free text in column AZ to explain why they selected 'Removed'. Is there any way to do this? The file is also shared. Many thanks

For some reason my match is exactly 1 cell down from where it needs to start and I have not been able to figure out why. Customer A should come up 1,2,3 but I'm Getting 2,3,4 =OFFSET('Customer Info'!$A$1,MATCH($B$1,'Customer Info'!$A:$A,0),1,COUNTIF('Customer Info'!$A:$A,$B$1)) Thank you.

@ Admins/Mods, if this is not a right place to post a request, kindly delete this post. Age old Data Validation List in excel needs update. Feature like Search as you type/Filter List as per typed characters/Search Suggestions/Auto complete should be there. Google Sheets has this feature since...

I have a spreadsheet I'm working on where I need to track daily sales, that connects with a commission structure. The current table I have shows all days of the month (29 days this month), I have created a Data Validation drop-down list with other months of this year. Is there a way, that when...

Hi there all, i want to set a data validation rule so that only the following number sequence can be entered to a cell: 000000-00 the hyphen is a must, if i didnt need the hyphen I would be fine setting this up. Any ideas? I use the data validation from the ribbon, and need a custom formula

HI Team, I need some help in data validation. I have years in column "A" like 2010,2011,2012,2013 so on ...and in column "B" I have quarters like Q1,Q2,Q3 so on....so, each year against quarters will be listed and not necessary every time 4 quarters some year should have 1 or 2 quarters as...

Good morning all, Does anyone know if there is a way to make the data validation lists searchable? I have items in my list that are similar so it would be more efficient if, when I started typing in a search bar, the results would be filtered by my letters. I understand that you can make a...

Hi everybody - I previously had a drop-down box with a Data Validation list. I then created a combo box in order to have auto-complete. I have since deleted the data that was assigned to the drop-down box via the Data Validation list. I want to assign a new set of data to the drop-down box /...