Hi Joel, find attached a sample file, I hope it is what you want. To avoid duplicates in the list it`s needed to mark 'Sort entries ascending' Be aware of Menu/Tools/Options/LibreOffice calc/General - Expand formatting, if it is activated, when selecting in A1, then A1 DataValidaty overwrite DataValidity in cell to the right, perhaps a bug. Regards. Miguel Ángel. DataValidation_SelectiingMatchingRows.ods <http://nabble.documentfoundation.org/file/n4175964/DataValidation_SelectiingMatchingRows.ods> -- View this message in context: http://nabble.documentfoundation.org/Dynamic-Validation-List-tp4175924p4175964.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted