Labeling a Unique/Distinct value not including any duplicates then pulling a list of those values

[willow1985]

I am looking for a formula that will mark what items on a list that are completely unique and do not have a duplicate (see below)

Book1
	A	B	C	D	E	F
1	Cost	Item	Unique Y/N		Unique List	Cost
2	$2.00	Apple	N		Corn	$0.56
3	$2.00	Apple	N		Strawberry	$5.00
4	$3.00	Pear	N		Banana	$1.50
5	$3.00	Pear	N
6	$2.50	Broccoli	N
7	$0.56	Corn	Y
8	$2.00	Apple	N
9	$5.00	Strawberry	Y
10	$3.00	Pear	N
11	$1.50	Banana	Y
12	$2.50	Broccoli	N
Sheet1

After which I would like a formula to pull a list of those unique values.
(Formulas needed are in yellow)

Any help with this would be greatly appreciated, thank you!

(Note: the original data will not be names of fruit/veggies but part numbers with a mix of numbers and characters if this matters, example 61300 or PT55522)

 

[willow1985]

No, you cannot use spill ranges in a table, you would need to use

IF(COUNTIFS([Part Number],[@Part Number])=1,"Y","N")

Perfect! Thank you very much!!

 

[Fluff]

You're welcome & thanks for the feedback.