delimited list

  1. G

    Data Validation - The list source must be a delimited list Error

    Ok, I have been searching all over the place to an answer to this problem. I am using a =IF(A1=5,List1,IF(A1=2,List2,"")) style data validation function for my lists. It is, and has been, working perfectly. Today I was asked to add another option to generate a new list. Should be easy. I...
  2. N

    Count unique values in a list (some delimited)

    Hi, I hope this makes sense, but I need some VBA to count all of the unique items in a list such as: 1 2 3 4,5,6 3 2 1,2,3 As in, some cells will only contain one number but others will contain a number of them in a single cell. Any help would be greatly appreciated Thanks
  3. H

    Odd validation issue

    Hi all, I'm having an issue with context-based validation. Basically I have a spreadsheet where I want the data validation drop-down list in column B to be based on the selected value from the drop down in column A. So, for example, if the drop down in column A gives you the values X, Y, and...
  4. S

    Dynamic Names Pointing to Blank-Delimited Blocks of Data

    Hello, I have a column of data that is blank-delimited into five blocks. The size of each block will vary, since the data comes from a web query. A blank (empty) cell tells me where a block ends and the next one begins. I would like to set up five dynamic names (e.g. Block_1, Block_2 and so...
  5. A

    Data Validation List & nested IF using Named Ranges: still getting 'The list source must be a delimited list, or a refernce to a single row or column"

    hello, I am using a data validation list with the following formula: =IF($C$6="Administrative Assistant</SPAN></SPAN>",AASI1,IF($C$6="Regional Program Advisor",RPASI1,IF($C$6="Regional HR Liaison",HRLSI1,IF($C$6="Financial/Administrative Assistant",FAASI1,"")))) I am getting the error...
    • ATKT
    • Thread
    • data validation delimited list named range nested if
    • Replies: 1
    • Forum: Excel Questions

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top