| View previous topic :: View next topic |
| Author |
Message |
Ihavequestions
Newbie
Joined: 06 Aug 2010
Posts: 1
Location: Austin, Tx
|
 Posted: Fri Aug 06, 2010 9:55 am Post subject: How to Filter out Duplicate without filtering out spaces? |
 |
|
I'm setting up a massive contact database, and I'm encountering a problem, due to my many duplication in subscribers; and many spaces left blank in certain columns. For example I have certain columns that will have names in them but then some that might not but they will have an email and a phone# in the same row. When I try to filter duplications out with the spaces it janks the list out of order.  This is very annoying please help.
_________________
Havoc Octavian Bloodsmith |
|
| Back to top |
|
 |
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Fri Aug 06, 2010 1:48 pm Post subject: Re: How to Filter out Duplicate without filtering out spaces |
|
|
| Ihavequestions wrote: | | I'm setting up a massive contact database, and I'm encountering a problem, due to my many duplication in subscribers; and many spaces left blank in certain columns. For example I have certain columns that will have names in them but then some that might not but they will have an email and a phone# in the same row. When I try to filter duplications out with the spaces it janks the list out of order. This is very annoying please help. |
Wel, my first thought is to suggest using a database not a spreadsheet but this is a general observation. I'm not much of a database user but I suspect that a single table db would be a start.
However since your data is currently in a calc sheet let's see what you are doing.
What are you filtering on?
Can you explain a bit what you mean when you say "it janks [sic] the list out of order".
Do you mean that various cells in a row suddenly are in a different row.? That is , a contact row is no longer intact?
What are you selecting when you apply the filtre (the entire data set or a subset)? If a subset is it a subset of the columns or a subset of the rows?
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
|
