I'm trying to set up an analysis sheet that looks at the number of people who have attended an event. They are marked with an "x" on a sheet as they arrive and an IF formula looks at whether that "x" exists and then copies the name across if it does. However as it works its way down the list it obviously skips the ones where there is no "x" and moves to the next giving a load of blank lines.
Is there a way of modifying the formula to ignore the ignore the blanks and keep all the results together please?
I've attached a sample of what I'm trying to do
Many thanks as usual.