HOW TO EXTRACT HIGHLIGHTED DUPLICATE ITEMS

M

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

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.
Sort by date Sort by votes
Hi
instead of relying on color, use the same criteria used to produce the conditional formatting and copy the data.
ravi
 
Upvote 0
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!
 
Upvote 0
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
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Question
Results by handicap - with ties. Look up by score without duplicates
Replies
4
Views
85
dkjonesau
D
H
  • Question
Match and sort different sized data sets
Replies
8
Views
354
Hammer123
H
Mel Smith
  • Solved
Two dynamic lists on two sheets. Check for and identify duplicates. How?
Replies
4
Views
134
mumps
mumps
C
  • Question
Excel Userform Listbox Search issues
Replies
3
Views
125
Akuini
Akuini
C
  • Question
How to get my macro to stop at the last recognized line
Replies
6
Views
208
Coco1
C

Forum statistics

Threads
1,214,929
Messages
6,122,315
Members
449,081
Latest member
tanurai

Share this page

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
Back
Top