Matching multiple columns.

[ThedoreHolley]

I have two spreadsheet that have names and dates on both. I trying to figure out the formula that will let me see if the names and dates match up with my main data sheet. Some names appear multiple times and and several names have the same dates. Example name in A2 has a date of 1 October 2022. Is there a way to see if that name and date match on another tab.

 

[awoohaw]

here are two solutions. But there are many, i'm sure;

Book1
	A	B	C	D	E	F	G
1
2
3	SM	2022-10-02	365 (FILTER)
4			2.00			AN	2023-05-02
5			OLDER VERSIONS (COUNTIFS)			KI	2023-05-02
6			2.00			OI	2023-05-03
7						UR	2023-05-05
8						XB	2022-10-02
9						BP	2022-10-02
10						SM	2022-10-02
11						SM	2022-10-02
12						YG	2023-05-04
13						EX	2023-05-04
Theodore Holley

Cell Formulas
Range	Formula
C4	C4	=ROWS(FILTER(F4:G13,(A3=F4:F13)*(B3=G4:G13)))
C6	C6	=COUNTIFS(F4:F13,A3,G4:G13,B3)