Comparing Lists

Sometimes it is necessary to compare information that is contained in two lists to see if there is duplication in the two lists.

To identify differences and duplicates place the two lists side by side on a sheet. Below is a screenshot detailing two lists of invoices. Unique invoices are not coloured, whilst duplicates have been highlighted with "Light Red Fill with Dark Red Text".

To highlight the duplicates:

Select both columns and then from the Home tab select Conditional Formatting,

then Highlight Rules and the Duplicate Values.

Then select Duplicate from the drop down (or if you want to highlight Unique items select Unique in the drop down), together with the formatting you want.

This will now allow you to easily identify, in this case duplicate items.


Featured Posts
Recent Posts
Archive
Search By Tags
No tags yet.
Follow Us
  • Facebook Basic Square
  • Twitter Basic Square
  • Google+ Basic Square

 

 


E: Office@iFRC.co.uk

 

T: (01889) 883860

 

 

CONTACT US:

 

iFRC Limited

1 Abbey Gardens,

Great Haywood,

Staffs. ST18 0RY

 

© 2015 iFRC Ltd