At 11:33 08/10/2013 -0700, Joel Madero wrote:
Indeed in B2 (first enter) it seems to work fine. I should have clarified, when I copy/paste in selected range (B column starting at B3) the value in B2 just gets repeated (ie. it's not finding unique values, instead it's just repeating the first found value in A column.
That's what happens for me if I drag the fill handle down the column, but - as I said - it works for me if I copy the first cell (B2 in your example) and paste it into later cells in the column. You need to copy the contents of the prototype cell (B2), not the contents of the Input Line for that cell.
I'll send you an example privately. Brian Barker -- To unsubscribe 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.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
