VehiclesFashionRecipesBlogsHuntTravelsSportFunHandmadeITEducation
Mini-Games
x

x
zakruti.com » IT - Software » IT, programs, coding
Excel Reducing Data Validation List - My Online Training Hub

Excel Reducing Data Validation List - My Online Training Hub

FBTwitterReddit

video description

Rating: 4.0; Vote: 1
Excel Reducing Data Validation List - My Online Training Hub As you select items from the data validation list (drop down list) they are no longer available to select in further cells. Download the Excel file and step by step instructions here: https://www.myonlinetraininghub.com/reducing-data-validation-list Thanks to MF Wong for the original solution which I've modified in this video. You can see his example here: https://wmfexcel.com/2018/11/14/dynamic-shrinking-dropdown-with-dynamic-arrays-in-excel-365/
Date: 2022-04-08

Comments and reviews: 6


Excellent madam I really like your vedieo especially your method of explanation . Thank you.
Actually I am trying to built automatic time table generator software in excel with lots of functions.
If there is a any function that represent the name reputation i number like if period repeated from Monday to Friday of particular subject or teacher it will show as 1 to 5
If this is possible.

reply

This is a great use of the new FILTER function and I can see numerous practical applications for resource allocation and budget setting. Just needs the business world to catch up with their Excel versions....could be some time indeed unfortunately -. Thanks for the ideas --
reply

This is a great idea, and clearly explained. Thanks. I would love to incorporate this onto some Excel workbooks I use at work. Unfortunately my organisation offers Excel 2010, so no new FILTER functionality available.
How could this be recreated in Excel 2010?
Thanks.

reply

Hi there! Is there any way to perform this action while excluding one item from the list, say... -TBD- we want to be available no matter how many times it shows up in the list? Thank you!
reply

This is awesome. We use Excel for a seating plan at work. This would be a great way to see who isn't assigned a desk and prevent assigning any person more than one desk. Thank you!
reply

Hi, This is amazing and helpful. Could you or anyone here help me with one more thing, i want the list to refresh on a daily basis. As i do this assignment everyday.. thanks
reply
Add a review, comment






Other channel videos