At 08:43 27/03/2013 -0400, Carl Paulsen wrote:
I too hadn't realized the value of the last parameter being 1 (meaning it takes the next number below). I had trouble getting the formula to work until I realized I had pasted the array from the email and some of the numbers were formatted as text, others not, so I was getting almost all #N/A.
That brings up another interesting point. When pasting material in from elsewhere, it is very often useful to use Edit | Paste Special... (or Ctrl+Shift+V) instead of ordinary Paste and then to select "Unformatted text". The Text Import window then gives you various ways to control how the material is imported. In the current case, ticking Space and "Merge delimiters" will produce something close to what is needed. Where necessary, you can even modify the individual column types at the bottom of the Text Import window to control how values are interpreted.
But you probably knew that ... Brian Barker -- For unsubscribe instructions e-mail to: users+help@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