vlookup with a difference

jaypatel

Active Member
Joined
Nov 25, 2002
Messages
385
Hi,

i have numerous "duplicated" rows (which i need to keep), where the only duplication is column a .....eg

a b c
1 r0010 124.14 1454
2 r0010 98.15 1455
3 s012 5.25 9852
4 s012 14.54 1045
5 s012 7.25 4876......

what would be the best solution to extract all the rows which has r0010 to another spreadsheet called "extract.xls". So i would need to extract rows 1 and 2 as they both have r0010. Vlookup does not work or i might be confused.

Jay
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

bjwillingham

Active Member
Joined
Jun 17, 2003
Messages
287
The easiest I think would be to do a quick pivot table on the data, subtotaling by column 1. Then double click on the subtotal amount and Excel will extract all the data to a new tab. You can then move the new tab to a new workbook.

Or you could do an Advanced filter and copy to another location.
 

bjwillingham

Active Member
Joined
Jun 17, 2003
Messages
287
I read your question too fast. I translated 'best' to easiest.

The best way is using the Advanced Filter.
 

crimlet

Board Regular
Joined
May 2, 2002
Messages
136
I have used a advance pivot to do this type of thing before. It is possible to incorporate into a macro and then copy into a new sheet which seems to suit your needs
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,820
Messages
5,772,462
Members
425,760
Latest member
paphon

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top