Why does the number of columns have to be odd? If you add one more column the problem is solved :)
If there is an absolute reason that the number of columns MUST be odd, then all cells starting from the second row need to check if the previous two cells are equal. You can do this with an IF function. Then you can copy the second row to as many as you need. Hope this helps ;) -- View this message in context: http://nabble.documentfoundation.org/Looking-for-an-easier-way-to-do-the-following-in-a-spreadsheet-tp3995544p3997093.html Sent from the Discuss mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
