Comparing Multiple Sheets

Marmalade

New Member
Joined
Oct 14, 2005
Messages
6
:x

Good Afternoon,

I have a workbook with 2 sheets containing data. I need to compare the 2 sheets and extract exact matches.

The 1st sheet is called Chris HQ and the data resides in column G3:G397 and the second (which is where I need to report the matches) is Chris Out column A2:A234.

Please can anyone help or I will be forced to check each one via Autofilter!

Thanks

M
 

Some videos you may like

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Watch MrExcel Video

Forum statistics

Threads
1,118,071
Messages
5,570,023
Members
412,304
Latest member
citrus
Top