listing names marked yes - pivot table?

[eamexcel]

Given the sample data below, I am trying to get Excel to return a list of the names marked YES for column B (Monday) and separately for column C (Tuesday). Using "countif" I can get a count, but I need the names listed. I think this is a pivot table function, but am having trouble getting anything other than a numerical summary of the names. Can Excel do what I need, is it through Pivot Table, and does anyone have any guidance for making this work?
Thank you so much,
Elizabeth



Name Monday Tuesday
jane yes yes
john no yes
jim yes yes
jack yes
jennie yes no
jerry no
julie yes no
jessie no yes

total yes 5 4

[DonkeyOte]

With the odd exception (via Custom Formats) Pivots can only show numerical data in the Data Field.

If we assume for sake of demo that:

a) your table is in A1:C9 (row 1 header)

b) your names in A2:A9 are unique

c) you wish to return names for Monday to say A15 onwards and Tuesday to B15 onwards then

Please Login or Register  to view this content.

bit of a sledgehammer but it should work.