Hi :) We can't see inside the zip file unless we register at the Excel forum. You could have a text cell list various chosen cells such as '=A1, B3, A2, C6, A4, B1 as randomly or ordered as you like.
You can also have nested IF statements so that if A1=3 it would go on to check to see if B3=4 or whatever. But i think you are asking something slightly different? Regards from Tom :) ________________________________ From: alesarrett <[email protected]> To: [email protected] Sent: Tue, 31 May, 2011 8:06:02 Subject: [libreoffice-users] Multiple selection in a validity range (Calc) Dear users, I'd like to have a validation cell accepting multiple items from a cell range, to have as a result, a list of item separated by a comma. Having as cell range 1 2 3 4 I'd like to be able to select from the validation cell, e.g. 2 and 3 and to have as a result 2,3 Is there a way to do this? Are there plans to include multiple selection in the validity tool? Are there any macro around that I could use to start from? Trying to find inspiration, I found this similar example in excel: http://www.excelforum.com/excel-general/646619-select-multiple-criteria-via-data-validation.html Is it easy to reproduce and customize in calc? Thank you for any hint. Ale -- View this message in context: http://nabble.documentfoundation.org/Multiple-selection-in-a-validity-range-Calc-tp3004869p3004869.html Sent from the Users mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted -- Unsubscribe instructions: E-mail to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/www/users/ All messages sent to this list will be publicly archived and cannot be deleted
