I have a variable numbers of data elements for each day, and I'd like to hide all but the last of each day (or export only the last-of-day values); is there an easy way?
Example data: row | date | reading number | value | ... 1 | 7/1/2011 | 1 | 3 2 | 7/2/2011 | 1 | 6 3 | 7/2/2011 | 2 | 7 4 | 7/2/2011 | 3 | 5 5 | 7/4/2011 | 1 | 4 6 | 7/5/2011 | 1 | 5 7 | 7/5/2011 | 2 | 6 So I'd like to extract: 1 | 7/1/2011 | 1 | 3 4 | 7/2/2011 | 3 | 5 5 | 7/4/2011 | 1 | 4 7 | 7/5/2011 | 2 | 6 Is there a way to use conditional formatting to hide a row, based on a test of the reading number of the current row compared to the reading number of the next row? -- Wayne -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In case of problems unsubscribing, write to postmas...@documentfoundation.org 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