CountIFs with Index and Date

[beginvbaanalyst]

Hello Everyone,

I'm trying to figure out a formula that shows if the date changes on a specific index it would result in a rejection status.
So i'm trying to group The index with the date received and if the table shows anything that's different from the date received date it's considered a rejection.
What's the best way to do this?
I thought a countifs with an IF statement would work but it shows everything as rejected for some reason.
We make trackers twice a day so if it carries over technically it doesn't mean it's been rejected, but if the date does change when we received it it does mean it was rejected.

Here is a sample

Source.Name	Formindex	Analyst	Task Type	Master Data Process	MD Rec'd	Priority	Status
AM - MD OTR 11.16.20.xlsx	136074​		ARTICLE_CHANGE	ARTICLE_CHANGE - Remove Simple Tire UPCS (see attached list) 11.06.20	11/12/2020​	Priority	Rejected
AM - MD OTR 11.17.20.xlsx	136074​	mtauras	ARTICLE_CHANGE	ARTICLE_CHANGE - Remove Simple Tire UPCS (see attached list) 11.06.20	11/13/2020​	Priority	Rejected
AM - MD OTR 11.18.20v.xlsx	136074​	mtauras	ARTICLE_CHANGE	ARTICLE_CHANGE - Remove Simple Tire UPCS (see attached list) 11.06.20	11/13/2020​	Priority	Rejected
PM - MD OTR 11.16.20.xlsx	136074​	mtauras	ARTICLE_CHANGE	ARTICLE_CHANGE - Remove Simple Tire UPCS (see attached list) 11.06.20	11/12/2020​	Priority	Rejected
PM - MD OTR 11.17.20.xlsx	136074​	mtauras	ARTICLE_CHANGE	ARTICLE_CHANGE - Remove Simple Tire UPCS (see attached list) 11.06.20	11/13/2020​	Priority	Rejected
PM - MD OTR 11.18.20.xlsx	136074​	mtauras	ARTICLE_CHANGE	ARTICLE_CHANGE - Remove Simple Tire UPCS (see attached list) 11.06.20	11/13/2020​	Priority	Rejected

Since the date changed from 11/12/2020 to 11/13/2020, it's an indication that the request has been rejected.

Would removing duplicates by the selection of formindex and mdrec'd together fix that issue?
Please help.
Thank you.

 

[Toadstool]

Hi Beginvbaanalyst,

You don't show the formula you tried but does this work?

Book1
	A	B	C	D	E	F	G	H
1	Source.Name	Formindex	Analyst	Task Type	Master Data Process	MD Rec'd	Priority	Status
2	AM - MD OTR 11.16.20.xlsx	136074		ARTICLE_CHANGE	ARTICLE_CHANGE - Remove Simple Tire UPCS (see attached list) 11.06.20	11/12/2020	Priority	Rejected
3	AM - MD OTR 11.17.20.xlsx	136074	mtauras	ARTICLE_CHANGE	ARTICLE_CHANGE - Remove Simple Tire UPCS (see attached list) 11.06.20	11/13/2020	Priority	Rejected
4	AM - MD OTR 11.18.20v.xlsx	136074	mtauras	ARTICLE_CHANGE	ARTICLE_CHANGE - Remove Simple Tire UPCS (see attached list) 11.06.20	11/13/2020	Priority	Rejected
5	PM - MD OTR 11.16.20.xlsx	136074	mtauras	ARTICLE_CHANGE	ARTICLE_CHANGE - Remove Simple Tire UPCS (see attached list) 11.06.20	11/12/2020	Priority	Rejected
6	PM - MD OTR 11.17.20.xlsx	136074	mtauras	ARTICLE_CHANGE	ARTICLE_CHANGE - Remove Simple Tire UPCS (see attached list) 11.06.20	11/13/2020	Priority	Rejected
7	PM - MD OTR 11.18.20.xlsx	136074	mtauras	ARTICLE_CHANGE	ARTICLE_CHANGE - Remove Simple Tire UPCS (see attached list) 11.06.20	11/13/2020	Priority	Rejected
Sheet1

Cell Formulas
Range	Formula
H2:H7	H2	=IF(COUNTIF($B$2:$B$9999,B2)<>COUNTIFS($B$2:$B$9999,B2,$F$2:$F$9999,F2),"Rejected","OK")