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, 09:57 PM

Marcia

Marcia is offline

Marcia uses Windows 7 32bit

Windows 7 32bit Marcia uses Office 2013

Marcia uses Office 2013

Office 2013

Expert

Join Date: May 2018

Location: Philippines

Posts: 553

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Default

Quote:

Originally Posted by Karen615

View Post

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

Karen, google COUNTIF and you'll find excellent websites providing detailed explanations. I go direct to Exceljet.

Reply With Quote