Check for Duplicates in 2 columns

**bwian1234** · 09-07-2018, 09:30 AM

Hi, hope I explain this correctly,

I have a worksheet, its an analysis of receipts with Columns:- Date, Paid by, Designation, Gross, Vat, Net
The List is quite long 1000-2000 rows.
I am trying to find a way of finding duplicate entries.
So i am trying to check the date column for the same dates and the gross column for the same amounts and highlighting only the rows that BOTH date and gross are the same.
I can sort the sheet in Date order to make it easier.
Is it possible, if so how ho I go about it.

This is what i'm after.

1/1/18 £10
1/2/18 £10
2/3/18 £99 <--- Highlight
2/3/18 £99 <--- Highlight
4/5/18 £99
4/5/18 £33

Thanks in Advance

I am also open to any other suggestions, I'm sure this is a common(ish) problem

**MarvinP** · 09-07-2018, 09:41 AM

Hi bwian,

Conditional Formatting should do what you want. If you create a helper column and concatinate the two columns together and then use the Duplicates format from CF it might be what you want.

If the above doesn't work then read this site below:
https://exceljet.net/formula/find-du...in-two-columns
for a possible formula solution.

**FlameRetired** · 09-07-2018, 11:04 AM

Duplicated post.

**FlameRetired** · 09-07-2018, 11:05 AM

Another way is to do it by formula.

With Applies to set A1:B6 and "Use formula to determine which cells to format" this formula

Formula:

Please Login or Register  to view this content.

	A	B
1	1/1/2018	£10
2	1/2/2018	£10
3	2/3/2018	£99
4	2/3/2018	£99
5	4/5/2018	£99
6	4/5/2018	£33

Check for Duplicates in 2 columns

LinkBack

Thread Tools

Rate This Thread

Display

Check for Duplicates in 2 columns

Re: Check for Duplicates in 2 columns

Re: Check for Duplicates in 2 columns

Re: Check for Duplicates in 2 columns

Thread Information

Users Browsing this Thread

Similar Threads

Macro to check against Columns & Delete Duplicates

Additional Code to check for duplicates in multiple columns

[SOLVED] Check for duplicates from two sheets of data based on two criteria (2 columns)

Macro concatenating columns together, exceptions with duplicates, delete duplicates

Macro to check for blank cell entry, copy previous value, and check for duplicates

Macro to check for duplicates and highlight duplicates

excel columns - check for duplicates

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions