LinkBack URL
About LinkBacks
I need a way where I can search for duplicates in the 1st column of 3 sheets. Can anyone help?!?!?!?!
I need a way where I can search for duplicates in the 1st column of 3 sheets. Can anyone help?!?!?!?!
Last edited by pierredjr; 03-09-2016 at 01:52 PM.
Thanks for doing that
conditional formatting may help to identify the duplicates
Or do you want to flag each one in the sheets in a new column
=OR (Countif( sheet1!A:A, value) >0, Countif( sheet2!A:A, value) >0,Countif( sheet3!A:A, value) >0)
Last edited by etaf; 03-09-2016 at 01:58 PM.
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
When I select all sheets on the bottom of the page, it's not letting me conditionally format them, like I can't click on it at all.
I used conditional formatting for each individual sheet to remove duplicates, but now I need to compare them with all 3 sheets
correction
=OR(COUNTIF(A:A,A1)>1,COUNTIF(Sheet2!A:A,A1)>1,COUNTIF(Sheet3!A:A,A1>1))
you could add into a new column on each sheet and copy down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks