Microsoft Office Forums - View Single Post - Matching Criteria against a range when criteria is not in contiguous cells??

Thread: Matching Criteria against a range when criteria is not in contiguous cells??

View Single Post

Old

08-15-2014, 01:23 AM

LuckyPunch LuckyPunch is offline

LuckyPunch is offline

LuckyPunch uses Windows 7 32bit

Windows 7 32bit LuckyPunch uses Office 2013

LuckyPunch uses Office 2013

Office 2013

Novice

Join Date: Aug 2014

Posts: 3

LuckyPunch is on a distinguished road

Default

Hi GMorris,

Try this
=SUM(IF(FREQUENCY(MATCH(D2:K2,D2:K2,0),MATCH(D2:K2 ,D2:K2,0))>1,1))

Enjoy

Reply With Quote