Hi,

1. Select column B2:B500 (I have assumed that row 2 is the header row)
2. Go to Data Filter Advanced Filter Copy to another location
3. In the list range, select B2:B500
4. Leave the criteria range blank
5. In the copy to box, select any blank cell on the existing sheet
6. When you click on OK, you will get all the unique names from column B.
Let's say the unique items get listed in range D2:D10
7. In E3, enter if(countif($B$3:$B$500,D3)=3,"Yes","No") and copy down

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Thocow" wrote in message
...
Hi, say if I had a spreadsheet as follows:
A B C D
1 E 3
2 E 6
3 E 6
4 C 6
5 C 6
6 C 4
7 D 4
8 D 3

I want to run a function that will return a single item from column A, i.e
my new column will contain:
E
C
D

And I want the function to tell me if this letter had a 3 next to it, so
it
would return:
E Yes
C No
D Yes

Obviously I'm applying this to a much longer list or I'd manually look it
up, I'm sure there must be a simple way of doing this which I'm
overlooking?