HOW TO EXTRACT HIGHLIGHTED DUPLICATE ITEMS

mani_singh

Well-known Member
Joined
Jul 24, 2007
Messages
583
Hi, i've got a sheet with some data across two columns (A & B IN SHEET 1)

what i've done is to set conditional formatting on the (sheet 1) A column to set duplicates to italic and red colour.

What i need to do is extract the highlighted red duplicates including the field next to them in column B to sheet 2 :unsure:

Once thats done i need to run a countif on the duplicate data on sheet two and on the non-duplicate data on sheet 1 and save them on a table on sheet 3[/b]

Thanks everyone!
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

ravishankar

Well-known Member
Joined
Feb 23, 2006
Messages
3,566
Hi
instead of relying on color, use the same criteria used to produce the conditional formatting and copy the data.
ravi
 

mani_singh

Well-known Member
Joined
Jul 24, 2007
Messages
583
ok i'll forget about using colour - but can anyone have an idea of a macro to do this:

hi everyone i need a macro to sort and collate the data

item repairer no.
K604 0
K61036 1
K754 0
K992 2
K90506 0
K489 2
K604 1
K11588 2
K489 2
K984 0
K604 3
K3697 1
K3903 3

i need to total how many times the each repairer has repaired each item - remember the numbers represent the repairer number not the times fixed

thanks everyone!
 

mani_singh

Well-known Member
Joined
Jul 24, 2007
Messages
583
sorry guys the table could have been clearer


item ---- repairer no.
K604 ---- 0
K61036 ---- 1
K754 ---- 0
K992 ---- 2
K90506 ---- 0
K489 ---- 2
K604 ---- 1
K115889 ---- 2
K489 ---- 2
K984 ---- 0
K604 ---- 3
K3697 ---- 1
K3903 ---- 3
 

Forum statistics

Threads
1,181,410
Messages
5,929,774
Members
436,688
Latest member
sunnyBNH013

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