Header Banner
wonderhowto.mark.png
Gadget HacksNext RealityFood HacksNull ByteThe Secret YumiverseInvisiverseMacgyverismsMind HacksMad ScienceLock PickingDriverless

How to Work around the 1-rule data validation limit in Excel

May 4, 2010 11:58 PM
Excel spreadsheet displaying a list of names with formulas in use.

Love Microsoft Excel? This clip contains a tip that just might induce you to. With this free video tutorial from ExcelIsFun, the 144th installment of his "YouTubers Love Excel" or YTLE series of free video MS Excel lessons, you'll learn how to work around data validation's one-rule limit by creating a second shrinking list that looses values as they are used in the data validation area.

Just updated your iPhone? You'll find updated Apple Intelligence capabilities, new wallpapers, and enhancements to Calculator, PDF cropping, and Live Voicemail, among other useful features. Find out what's new and changed on your iPhone with the iOS 18.3 update.

Related Articles

Comments

No Comments Exist

Be the first, drop a comment!