A List of Names

[allgeef]

In Column B1:B35 I have names. In Column C3:C35 I type “D-1” next to different names. For example, I type “D-1” five times adjacent to five of the thirty-five names. In Column K1:K5 I would like a formula that would list each of the names from Column B1:B35 that have “D-1” next to their name in C3:C35. Thank you

[tigeravatar]

allgeef,

Attached is an example workbook based on the criteria you described.
In column B is a list of names starting in B3 and going to B35
In column C is the D-1 designation
Cell K1 is a header cell containing the text "D-1"
In cell K2 and copied down is this formula:

Please Login or Register  to view this content.

Does that work for you?

[shg]

You could autofilter col C for "D-1"

[allgeef]

Wonderful, this is precisely what I was looking for. Thanks