create a string of results from column A that have specific value in column b

[blackspiral]

I want to create a string of values to put in a field on sheet2 using data from sheet1. The data needs to be all usernames that are administrators.
example

Usernames	Roles
Bob	Administrator
James	User
Todd	Administrator
Steve	User

this should return "Bob, Steve" to a field on sheet2

[dredwolf]

See if this UDF will work for you :

Please Login or Register  to view this content.

Copy above code, Open VBA editor (Alt+F11), Insert->Module; Paste the code,then save and exit editor

Copy the Role Names into Row 1 of sheet 2, then this formula into A2 of sheet2:

Please Login or Register  to view this content.

Drag across
(see attached)

Hope this helps