I have a guest list, with attendance marked yes, no or blank. On a separate sheet, i'd like a report of all those that said yes.
At the moment I'm using the below, but that leaves lots of blank cells, which is not very useful. Can anyone help?
=IF(lista!H4="yes",lista!A4,"")
there's also a listb
Bookmarks