Microsoft Office Forums - View Single Post - [Solved] Finding Duplicates & Unique Values in More Than One Sheet

Thread: [Solved] Finding Duplicates & Unique Values in More Than One Sheet

View Single Post

Old

03-08-2020, 08:15 PM

Karen615

Karen615 is offline

Karen615 uses Windows 7 64bit

Windows 7 64bit Karen615 uses Office 2010 64bit

Karen615 uses Office 2010 64bit

Office 2010 64bit

Competent Performer

The original poster

Join Date: Jun 2011

Location: Chicago

Posts: 112

Karen615 is on a distinguished road

Default

How exactly does this formula work?
=COUNTIF(Sheet1!A$2:$A$14,$A2)>0

Reply With Quote