How match duplicate entry

[Pizzaman22]

Hello, I was looking for help on how to match the following
A. B. C.
Address | House Items | Received item
123john_street | Spoon | Yes
123john_street. | Fork. | Yes
123john_street | Knife | Yes
255john_street. | Apron. | No

So, what I need it’s to do is
Only Exact match “123john” so the first (6 characters) and if already the exact “address” took any items from “house items” previously then provide a “yes” or “no” value in the “received item” Column.

Any help would be great! Thanks!

 

[Pizzaman22]

It would be best if you can post some sample data.
So do you want the Count for Today Only, or a Total?
Also, I'm not sure if you need to actually list out "Fork", "Spoon", "Knife", etc. as in my formula in Post #12, Unless there may be something Else in Column B you Don't want counted

Your right, I would like all in column B to be counted . Today only please.
Address | Items | Received spoon| date |. # of items
123john_street | Spoon | Yes. | April 18|. 2
123john_street. | Fork. | No |. April 18. 1
123john_street | Knife | No April 18| 1
255john_street. | Spoon. | Yes |april 18| 1
123john_street |.spoon |. Yes |April 18 |2

 

[jtakw]

You've changed your setup, so I'm unsure How you want your data, this is my assumption:

Book3.xlsx
	A	B	C	D	E	F	G	H	I
1			Received				# of Item Today
2	Address	Items	Spoon	Fork	Knife	Date	Spoon	Fork	Knife
3	123john_street	Spoon	Yes	No	No	4/18/2021	2
4	123john_street.	Fork	No	Yes	No	4/18/2021		1
5	123john_street	Knife	No	No	Yes	4/18/2021			1
6	255john_street.	Spoon	Yes	No	No	4/18/2021	1
7	123john_street	spoon	Yes	No	No	4/18/2021	2
Sheet908

Cell Formulas
Range	Formula
C3:E7	C3	=IF($B3=C$2,"Yes","No")
G3:I7	G3	=IF($B3=G$2,COUNTIFS($A$3:$A$12,LEFT($A3,6)&"*",$B$3:$B$12,G$2,$F$3:$F$12,TODAY()),"")

 

[jasonb75]

Today only please.

Today, or 'Same day'?

This is how I've interpreted it, but as before, your example does not match your description in the Yes / No column.

Book1 (version 1).xlsb
	A	B	C	D	E
1	Address	Items	Received	Date	# of items
2	123john_street	Spoon	No	18-Apr	2
3	123john_street.	Fork	No	18-Apr	1
4	123john_street	Knife	No	18-Apr	1
5	255john_street.	Spoon	No	18-Apr	1
6	123john_street	spoon	Yes	18-Apr	2
Sheet5

Cell Formulas
Range	Formula
C2:C6	C2	=IF(COUNTIFS(A$1:A1,LEFT(A2,6)&"*",B$1:B1,B2,D$1:D1,D2),"Yes","No")
E2:E6	E2	=COUNTIFS(A$2:A$6,LEFT(A2,6)&"*",B$2:B$6,B2,D$2:D$6,D2)

 

[Pizzaman22]

Thank you so much guys.. all good now!! Your help means so much!!

 

[jtakw]

You're welcome.