Duplicate Values, Multiple Criteria 2 different data sets.

[Szucchari]

Hi,

We have a tracking sheet that needs to be updated daily. We take a stock report and paste it next to yesterday tracking in the same tab. We need to keep the exact matches on the tracking and remove the rows that no longer match from the tracking and then paste the accounts that are not matching on the stock report and add them to tracking.

The issue I am having is I am unable to just use conditional formatting on 1 cell to find the exact match, I need to use multiple cells to find the exact match. I have no idea how to do that I have been trying for a few days now and I am throwing in the towel. please help!
Below I have added the columns of the cells that would need to match and preferably highlight the whole row, so we know to keep them on the tracking and not to add them from the stock report. The "tracking sheet" is columns A: AB. the additional columns are the "stock report" AD: AS.

In the example below only A3:O3 should highlight on the "tracking sheet" and AD1:AO1 should highlight on the "stock report"

Thank you for any help you can give!

A	I	J	O		AD	AK	AL	AO
Account	Company	User	Time stamp		Account	Company	User	Time stamp
555	Alpha	John	1/5/25 6:03:52PM		6098	Beta	Jane	12/2/2024 9:37:29AM
556	Farmer	Joe	11/25/24 8:45:25AM		569	Farmer	Joe	12/23/24 11:07:42AM
6098	Beta	Jane	12/2/2024 9:37:29AM		556	Bravo	John	12/26/24 1:48:52PM

 

[hagia_sofia]

Hello, what version of Excel are you using?

 

[Szucchari]

Hello, what version of Excel are you using?

2016 still.

 

[Fluff]

2016 still.

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[hagia_sofia]

Many thanks. So maybe something like:

=AGGREGATE(14,6,($AD$2:$AD$4=A2)*($AK$2:$AK$4=I2)*($AL$2:$AL$4=J2)*($AO$2:$AO$4=O2),1)>0

for the A:O range?