 |
|
|
|
Next: REQ: Stopping RUN commands from clearing
|
| Author |
Message |
External
Since: Jan 12, 2010
Posts: 1
|
(Msg. 1) Posted: Tue Jan 12, 2010 10:45 pm
Post subject: advance filter unique records except on column
Archived from groups: microsoft>public>excel (more info?)
|
|
|
Is there a way to filter a database to find unique records where one column
is ignored?
I have over 6,000 records with the following columns.
Cust_rec, Bco, pol_csr, Expires, Cust_name, Cust_attn, Pol_type
I want to eliminate duplicates (there are many) but the last column "policy
type" should be disregarded.
Any suggestions? |
|
| Back to top |
|
 | |
External
Since: Oct 17, 2008
Posts: 38
|
(Msg. 2) Posted: Wed Jan 13, 2010 7:01 am
Post subject: Re: advance filter unique records except on column
Archived from groups: per prev. post (more info?)
|
|
|
You could use data|filter|advanced filter (in xl2003 menus).
Select the first 5 columns in your table and excel will use that in the advanced
filter dialog.
Make sure you check the "Unique records only" checkbox.
Herb Segal wrote:
>
> Is there a way to filter a database to find unique records where one column
> is ignored?
>
> I have over 6,000 records with the following columns.
>
> Cust_rec, Bco, pol_csr, Expires, Cust_name, Cust_attn, Pol_type
>
> I want to eliminate duplicates (there are many) but the last column "policy
> type" should be disregarded.
>
> Any suggestions? |
|
| Back to top |
|
| |
External
Since: Jan 13, 2010
Posts: 1
|
(Msg. 3) Posted: Wed Jan 13, 2010 8:27 am
Post subject: Re: advance filter unique records except on column
Archived from groups: per prev. post (more info?)
|
|
|
Thank you so much. It worked!
"Dave Peterson" wrote in message
> You could use data|filter|advanced filter (in xl2003 menus).
>
> Select the first 5 columns in your table and excel will use that in the
> advanced
> filter dialog.
>
> Make sure you check the "Unique records only" checkbox.
>
> Herb Segal wrote:
>>
>> Is there a way to filter a database to find unique records where one
>> column
>> is ignored?
>>
>> I have over 6,000 records with the following columns.
>>
>> Cust_rec, Bco, pol_csr, Expires, Cust_name, Cust_attn, Pol_type
>>
>> I want to eliminate duplicates (there are many) but the last column
>> "policy
>> type" should be disregarded.
>>
>> Any suggestions?
>
> --
>
> Dave Peterson >> Stay informed about: advance filter unique records except on column |
|
| Back to top |
|
| |
| Related Topics: | Formulas Instead of Advanced Filter - Hi there, I have Excel 2003 and want to have formulas that do the same work as Advanced Filtering. I currently have a system that looks at data in one column (X) and, with a mixture of If, Index and Match formulas, determines unique data and places...
Filter rows/transactions to another sheet. - Hi I have a sheet with 6500 transactions in rows. Each row contains an account no, amount, etc I would like to have Excel automatically copy all the rows/transactions on each account to a separate sheet in the same workbook (one account per sheet)....
How to use goal seek on column - Hi! I have a formula in cell C which is dependant on values in cell A and B. I use goal seek to adjust the value in cell A to meet the goal for C. This works perfectly. However I would like this to be performed on all rows in column C. Is this possible?...
Visible row index after applying a filter in Excel - Does anyone know an excel function that will give the index of the visible row after filtering or sorting a table? Say, I have a table like this: type time place c 12:20 1 f 12:40 2 c 13:30 3 f 14:20 4 Table is....
fill blank cells in a column - hello, how can i fill specific blank cells in a column. i tried find/replace without success. thanks |
|
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum
|
|
|
|
|
|
|
FAQ
Search
Profile
Private Messages
Log in
