HOW TO EXTRACT HIGHLIGHTED DUPLICATE ITEMS

[mani_singh]

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

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!

 

[ravishankar]

Hi
instead of relying on color, use the same criteria used to produce the conditional formatting and copy the data.
ravi

 

[mani_singh]

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]

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