Unique function to exclude a text character

[DDT123]

Greetings all,

I have a column that includes employee's names as well as other data. The employee's names are in lastName [comma] firstName format (Doe, John). I'd like to use the Unique function to list all unique values that does NOT have a comma. I've tried this formula which didn't work... =UNIQUE(FILTER($B:$B,$B:$B<>"*E1*")). **E1 is a helper cell which has a comma** I'd also like for the formula to exclude cells which have numbers if possible, but no biggie if that's too complicated.

Any help would be greatly appreciated.

 

[AhoyNC]

It would help if you could post some examples and the expected result.
Maybe something like this:

Book1
	A	B	C
1	Doe, Johm		John Doe Test1
2	John Doe Test1		Sam young Test1
3	Sam young Test1		John Paul Test2
4	John Doe Test1
5	John Paul Test2
6	Paul, John Test2
7	John Paul Test2
Sheet1

Cell Formulas
Range	Formula
C1:C3	C1	=UNIQUE(FILTER(A1:A7,NOT(ISNUMBER(SEARCH(",",A1:A7)))))
Dynamic array formulas.

 

[DDT123]

It would help if you could post some examples and the expected result.
Maybe something like this:

Book1
	A	B	C
1	Doe, Johm		John Doe Test1
2	John Doe Test1		Sam young Test1
3	Sam young Test1		John Paul Test2
4	John Doe Test1
5	John Paul Test2
6	Paul, John Test2
7	John Paul Test2
Sheet1

Cell Formulas
Range	Formula
C1:C3	C1	=UNIQUE(FILTER(A1:A7,NOT(ISNUMBER(SEARCH(",",A1:A7)))))
Dynamic array formulas.

Awesome! That worked!!