[tdf-discuss] Re: Looking for an easier way to do the following in a spreadsheet

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 discuss+help@documentfoundation.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.documentfoundation.org/www/discuss/
All messages sent to this list will be publicly archived and cannot be deleted