Data Extract To Range

  • Thread starter Thread starter Ken Wright
  • Start date Start date
K

Ken Wright

Select range and do Data / Filter autofilter. Click on the dropdown fo the
field in question and choose your citeria. Select visible data and do edit / Go
To / Special / Visible cells only. Now Ediytt / Copy and then paste to where
you need to.

Can also do this with Advanced Filter
 
In Excel 2K I'm trying to extract rows of data where two or more of the rows
have the same number in one field. I want to extract such rows to a separate
area of the worksheet - I'm sure I've done this before in a previous version
of Excel but I've forgotten how!

Many thanks,

Kelvin
 
Ken -

Thanks for your reply, however I'm having problems with how I should set the
criteria for the filter so that Excel looks for rows which have the same
value in the field, rather than a field which matches a specific criteria...
any ideas?

Many thanks,


Kelvin
 
Can you give us a small example of your data layout, including a matching pair
that you would ike to filter on.
 
Are you just flagging duplicates in Col A, or can the same data in A have
different dates in B? Assuming that you only care about Col A and the data in
there being duplicated:-

With your data in say A1:B1000, with headers in A1:B1

In cell C2 put the following formula:-

=IF((COUNTIF($A$2:A2,A2)-1)=0,"","Dup"&(COUNTIF($A$2:A2,A2)-1))

Now copy down and it will tag all your duplicate records.

Select Col C and do Data / Filter / Autofilter and filter on Non-Blanks. Now
select all the data you can see, do Edit / Go To / Special / Visible cells only,
then Edit / Copy then paste to wherever you want. If you also want to delete
them from the original range, then select the data, do edit / go to / visible
cells only, then Edit / Delete / Entire row
 
Back
Top