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...

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
Top