Hi All,
So I stumbled across instructions on how to do this in Excel but can't
get the same result in LibreOffice.
http://www.get-digital-help.com/2009/03/30/how-to-extract-a-unique-list-and-the-duplicates-in-excel-from-one-column/
Suggestions appreciated as always
All the best,
Joel
--
At 10:43 08/10/2013 -0700, Joel Madero wrote:
So I stumbled across instructions on how to do this in Excel but
can't get the same result in LibreOffice.
http://www.get-digital-help.com/2009/03/30/how-to-extract-a-unique-list-and-the-duplicates-in-excel-from-one-column/
Suggestions appreciated a
The first formula given at that web page worked for me once I'd
tinkered with the details to fit my actual case. And I needed to
replace commas by semicolons. (The formula as given will not find
instances of zero in the list.)
Note that it is an array formula, so you need to complete it us
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 fo
At 19:11 08/10/2013 +0100, Brian Barker wrote:
At 10:43 08/10/2013 -0700, Joel Madero wrote:
So I stumbled across instructions on how to do this in Excel but
can't get the same result in LibreOffice.
http://www.get-digital-help.com/2009/03/30/how-to-extract-a-unique-list-and-the-duplicates-in-e