| View previous topic :: View next topic |
| Author |
Message |
karlp
Newbie
Joined: 21 Sep 2010
Posts: 1
|
 Posted: Tue Sep 21, 2010 11:39 pm Post subject: how do I find duplicate values in a spreadsheet? |
 |
|
| how do I find duplicate values in a spreadsheet? I'd like to find duplicate values in 2 of my collumns. |
|
| Back to top |
|
 |
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Wed Sep 22, 2010 9:50 am Post subject: Re: how do I find duplicate values in a spreadsheet? |
|
|
| karlp wrote: | | how do I find duplicate values in a spreadsheet? I'd like to find duplicate values in 2 of my collumns. |
Well one way is to use a third column with something like this:
=IF(A1=B1; "TRUE";"FALSE")
and filter out all the TRUES, that is, duplicates
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
|
