Count if value is duplicated in column and also matches adjacent cell value

**arfa17** · 07-20-2015, 10:44 AM

Can someone help...

I need to know if cell A2 is duplicated anywhere in column A AND has the same adjacent value in column B.

i.e. it has a duplicate item title AND the same site listed ID.

If someone could give me the formula to bring back TRUE or FALSE or the equivalent it would be much appreciated.

**samba_ravi** · 07-20-2015, 10:58 AM

C2=IF(COUNTIFS($A$2:$A$39947,$A2,$B$2:$B$39947,$B2)=1,"No duplicates","Have Duplicates")

Try this and copy towards down

Count if value is duplicated in column and also matches adjacent cell value

LinkBack

Thread Tools

Rate This Thread

Display

Count if value is duplicated in column and also matches adjacent cell value

Re: Count if value is duplicated in column and also matches adjacent cell value

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Count Quantity if adjacent column matches criteria

[SOLVED] count duplicated string in Range for each letter,Non Adjacent Row

[SOLVED] Count partial text matches in adjacent column

[SOLVED] If number in Column A matches number in column B - Copy B cell and adjacent cells ?

[SOLVED] Look for duplicated & unique values in adjacent column. Perform math on result. . .

If cell matches any value in Column insert value in adjacent column

Hard? SUM the values of a column that matches a flag in an adjacent column

Bookmarks

Bookmarks

Posting Permissions