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!

 

[jasonb75]

You still haven't clarified why the first row is "Yes". Going by the logic you describe, it should be "No".

Book1
	A	B	C
1	Address	Item	Received
2	123john_street	Spoon	No
3	123john_street.	Fork	Yes
4	123john_street	Knife	Yes
5	255john_street.	Apron	No
Sheet7

Cell Formulas
Range	Formula
C2:C5	C2	=IF(SUM(COUNTIFS(A$1:A1,LEFT(A2,6)&"*",B$1:B1,{"Spoon","Fork","Knife"})),"Yes","No")

 

[jtakw]

Jason's right, your first result should be "No"

Book3.xlsx
	A	B	C
1	123john_street	Spoon	No
2	123john_street.	Fork.	Yes
3	123john_street	Knife	Yes
4	255john_street.	Spoon	No
5	444john_street.	knife	No
6	255john_street.	Fork	Yes
Sheet916

Cell Formulas
Range	Formula
C1:C6	C1	=IF(COUNTIFS(A$1:A1,LEFT(A1,6)&"*",B$1:B1,"<>")>1,"Yes","No")

 

[Pizzaman22]

Thank you guys, your actually right, I missed that, the first should be no. Thanks so much for the help!!!!

 

[jtakw]

You're welcome, thanks for the feedback.

 

[Pizzaman22]

Ok I have a last question (haha)
If I were to count how many “john123” forks he took for today’s current date and spit that out on A new column, how would I do that? Use the count function?

 

[jtakw]

Well, obviously, we'll need a column with dates associated with when the item was taken.
And Yes, COUNTIF or COUNTIFS would do.

 

[Pizzaman22]

Thanks for the fast reply. Yes I have a date Column now.
If have
(Qty Column) E2=COUNTIF(B2:B10, {"Fork”,"Spoon",”knife”}))

 

[jtakw]

That formula won't work as-is you'll need to SUM the COUNTS

=SUM(COUNTIF(B2:B10,{"Fork","Spoon","knife"}))

But what about factoring in the Name, and Dates??

If you need help with the formula, post some sample data.

 

[Pizzaman22]

Your just awesome, thank you so much. I am very new to this so please forgive my ignorance.
So I put the date in the “E” Column and address in the “A” column .
So if 123John_street (A) on today’s date (E) took two forks (B) then in column “ E” would say 2 for example

 

[jtakw]

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?