Find Duplicates on two worksheets

[bradnick]

Hi all hope someone can help, Im working with a large amount of data,

Firstly i have one worksheet with two sheets, sheet1 and jeffo

Secondly the data i need to compare is in column A on both sheets and consits of both numbers and letters i.e 027D-56-4070

What i need to achive is to compare both sheets for duplicate entrys and to highlite the duplicate entrys in colum A of sheet1

Any help would be appreciated

 

[RomulusMilea]

Hello and welcome on board,

Go to sheet "Jeffo", select all data in column A and create a name of the range selected, e.g. "Jeffo".

To create the name use "Name box" located on the top left corner of your sheet, right above column A. Click there while cells are selected, write Jeffo and press Enter.

Then, go to Sheet1, select the range of data in column A and apply conditional formatting formula:

=OR(A6=Jeffo)

Of course, you need to define the formatting (fill color, font, etc.).

I have created a simulation, the dummy data I used starts in cell A6 downwards, for both sheets.

Please confirm this solves your problem.

 

[Misca]

Try using conditional formatting with a formula =COUNTIF(YourSheet2Range,$A1)>0.

You have to name your range on Sheet2 to get the conditional formatting to work. Naming a range is simple: Just select the range and type the name what you want to use (just one word & can not start with a number) to the address bar (= the little box right next to the formula bar).

 

[bradnick]

Hello and welcome on board,

Go to sheet "Jeffo", select all data in column A and create a name of the range selected, e.g. "Jeffo".

To create the name use "Name box" located on the top left corner of your sheet, right above column A. Click there while cells are selected, write Jeffo and press Enter.

Then, go to Sheet1, select the range of data in column A and apply conditional formatting formula:

=OR(A6=Jeffo)

Of course, you need to define the formatting (fill color, font, etc.).

I have created a simulation, the dummy data I used starts in cell A6 downwards, for both sheets.

Please confirm this solves your problem.

=OR(A6=Jeffo)
I have followed the instructions and now have the formulae =OR(A6=Jeffo) in colum A of sheet1 all that is being displayed in box A1 is the word FALSE, how do i get the cells to highlite in colour, Thanks