repeated words in excel

[mitko2122]

Hi all,

I have two different sheets in excel. Sheet one has
A1 Expekt
A2 Gamebookers
A3 GWbet

Sheet two has

A1 Expekt
A2 Gamebookers
A3 GWbet
A4 Intertops

Is there any way to find which word from sheet 2 is missing in sheet 1.

Thanks in advance for your help.

 

[njimack]

Excel Workbook
	A	B
1	Expekt	TRUE
2	Gamebookers	TRUE
3	Gwbet	TRUE
4	Intertops	FALSE
Sheet2

 

[T. Valko]

Hi all,

I have two different sheets in excel. Sheet one has
A1 Expekt
A2 Gamebookers
A3 GWbet

Sheet two has

A1 Expekt
A2 Gamebookers
A3 GWbet
A4 Intertops

Is there any way to find which word from sheet 2 is missing in sheet 1.

Thanks in advance for your help.

One way...

Enter this formula on Sheet2 in cell B1:

=IF(COUNTIF(Sheet1!A:A,A1),"","Missing")

Copy down as needed.

 

[shift-del]

Hi

=INDEX(Sheet2!$A$1:$A$4,MATCH(0,COUNTIF(Sheet1!$A$1:$A$3,Sheet2!A1:A4),0))

Enter with CTRL-SHIFT-ENTER

 

[mitko2122]

Wow that was fast!
Thanks to all, your help is highly appreciated.

My problem is solved.

 

[T. Valko]

Wow that was fast!
Thanks to all, your help is highly appreciated.

My problem is solved.

You're welcome. We appreciate the feedback!