dependent data

  1. S

    If X in C4, copy to E4, Dependent Validation

    I've set up Dependent Data Validation so when a specific Session is selected only specific options are available in the next two columns. However, the third column the user is to input a number. The only restriction is for the Session called Previous Group. Those two dependent validation columns...
  2. P

    Fix issue with duplicates in Data Validation and Dependent Data Lists

    I am trying to create a spreadsheet that takes data from another spreadsheet and produces drop-down menus for each field (removing duplicates), while narrowing down our next selections based on using indirect(). What I originally did was follow tutorials like this. It works, but only for the...
  3. 9

    How do you lock, link, or associate a single row of data so it stays together during a sort on another worksheet?

    I have a spreadsheet in which Worksheet 1 is a master list of names andgroup assignments. Worksheet 2 sorts these names into the respective groups. Worksheets 3 and 4 are group specific worksheets, pulling the sorted group lists from worksheet 2 into column A. Attendance Data for each...
  4. M

    need unique client dishcarge count dependent on having a discharge date

    Hello. I need some help with an array formula to count the unique clients discharged, provided they have a discharge date in another column in the same row. I know how to do unique count, but don't know how to make it to where on the unique client #'s with a discharge date are counted (some...
  5. R

    dependent data from dropdown

    easy one im sure, but i cant work it out! :confused::confused::confused: If cell A had a working dropdown menu, how does one make Cell B apply data based on that choice: i.e if user chooses apple from cell one, the quantity of apple in cell 2 ALWAYS 6 if user chooses orange from cell one, the...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top