1. MikeMcCollister

    Little Green Triangle at Upper Left of Cell

    I have some cells with data validation turned on with list of values for the allow list. I've disabled the input message and error alert because the list contains the most common entries for these cells so other values are OK. However, when I put in other values, a little green triangle shows up...
  2. W

    Save all versions of data validation to one PDF

    I have a worksheet named 'RAG' that creates individual sheets for each student. currently I have the code below that prints each validation. However, I'm looking at a way to have option to save it as one PDF document. I will want to be able to choose file path and name at point of save. Any...
  3. F

    two Conditional formatting

    allow to enter value in cell, only if 1. data contain 1 time "x" value between two numeric value . & both numeric values should not be more than 99, e.g 34x45.5, (allow)...... 21x56.44 (allow) 23c45.5, (not allow). 23 x 45.5 (any space not allow) 101x22 (numeric more than 99 not allow)
  4. V

    Data Validation for Alphanumeric and Hyphens (dashes) for a column

    Hello, I'm trying to add Data Validation to 50 cells in a column that will only accept: Alphanumeric Hyphens (dashes) No restrictions for length. I did find some examples, but they are all for a single cell. If I try to change it to a range it breaks and won't let me save. I tried this...
  5. M

    Data Validation List Based on Meeting Criteria in Adjacent Cell

    I am trying to make a data validation list on Sheet1 that references all non-blank items in column A on Sheet2. I have accomplished this pretty easily (although, is there a way to exclude the header without just selecting a long range like "A2:A5000"?). Now, I want to trim that list to only...
  6. J

    Adding validation in excel according to another column from another sheet

    I have a excel sheet called data with 3 columns: id, name I have another sheet called list with 3 columns: id, name I have made a data validation on column name in data sheet with this > formula: =list!A$2:$A$37000 its working fine and gives me a drop down list from my names in list and...
  7. S

    Data validation list - the order of computing formulas

    Hello, the good example of drop down list is here: Prevent duplicates in cells where there is a dropdown list It is not working when typing allowed value, for example "peaches" and pressing enter on the keyboard. The value "peaches" is accepted when it is choose directly from the list or...
  8. K

    VBA code to highlight empty cells that are mandatory

    Hello I needed help with identifying all required data that has been left blank. I have multiple workbooks and within each workbook there are multiple worksheets, all have employee related rows of data. I wanted a macro/vba script to be able to automatically go through each worksheets within...
  9. L

    Nested or formula combinations

    Hi Guys, Columns B, C, D, and E contain a list look-up (Yes or No) Earlier today, you guys helped me that if column B and/ or E has "Yes", to return certain text (Thank you!) I placed the updated functionality in column F. Then I wanted the user to identify the scope of work based on the...
  10. L

    Force user to select from list on adjacent column if option from list is selected

    Hi All, A user on this site kindly provided me with the below code. The code done exactly what I wanted at the time: "I have a dropdown list on column AY with 'In-Scope' & 'Removed' as the options. If a user selects 'Removed' I want to force them to enter free text in column AZ to explain why...
  11. M

    Combo Chart - linking data to different data points

    I have attempted to attach the mini sheet below with a Data Input table in which I have created. All of the cells in the Standard columns have a drop down list connected to them including the following: Year 1, Year 2, Year 3 etc. The cells in the ticks column is a manual entry...
  12. S

    Date validation on command button

    Hi everyone, I apologise for being noob, I'm new to posting on this forum (even though I've been a member for ages!) I'm having difficulty with validation (not my own btw... Excel's) validation works fine when you enter text into a cell, but it doesn't work when you are working with a user...
  13. J

    Dependent data validation question

    Hi all, i feel like i've watched a million youtube videos and read a million articles and they all seem sooo similar to what i'm trying to accomplish, but i just can't quite get there... Here's the situation; Excel 2016, will be a shared workbook so no tables allowed, workbooks will likely have...
  14. darrenmccoy

    How to build formula to check address structure?

    Hi, Could you guys help me with what type of formula would I use to check address formatting and return a true or false? An example case would be the format of address must be (number, street names, location, state zip) with the commas and spaces. ID FULL ADDRESS VALIDATION 611762 101...
  15. A

    Show results based on 3 Data Validation list

    Hi community, I have big table of monthly spending, i wanna know how can i show results based on Data Validation list choice, 1-List shows Models ( E:E ) 2-List shows Department ( B:B ) 3-List shows Month I need formula to return matching all 3 list, can anybody help me please?
  16. A

    Data Validation List based on Cell Value

    I have a table in which currency in A and values in B <tbody> CAD 2 USD 13 AUD 15 CAD 5 CAD 11 </tbody> I enter text CAD in C1 and make data validation list in D1. Based on text in C1 data validation only shows the value against CAD. like image attached.
  17. G

    Data validation drop down list source to lookup a value and list unused items ?

    Hello everyone! In a sheet i have the following: A2=Joe; A2= Jack; A4= John and for each name there is a recommended Name list in B2:B4 (Fruitlist;Vegetableslist;Dairylist) A2:A4 is defined as Names G2:G5 is defined Fruitslist L2:L4 is defined Vegetableslist Q2:Q4 is defined Dairylist In B7...
  18. S

    Moving around the screen

    Hi all I have a data validation box in cell b2 with the following options, Q4-19, Q1-20, Q2-20. Columns a:c are locked data for Q4-19 starts in column d to p data for Q1-20 starts in column q to ac data for Q2-20 starts in column ad to ap Based on the data validation selection I want the...
  19. E

    Data Validation - error

    I have a data validation with a nested if statement. =IF(R8="D18",D18_OP,IF(R8="D24",D24_OP,IF($R$8="D34",D34_OP))) It works fine as long as I don't have D18 in R8. D18_OP named range = "Not Applicable". When D18 appears in R8 the drop down will not load with "Not Applicable" nor can I select...
  20. J

    Macro removes data validation from cell

    Hi, I have an excel sheet to track project status. I've created a Macro that moves the a row from Sheet1 to Sheet2 when 'Complete' is selected from data validation drop down. The problem is, when the row is moved to sheet 2, the now empty row loses all it's data validation. Is there any way...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back