I have a sheet with the following data:
A B 1 Raisa A 2 Mellissa A 3 Emma A 4 Slyvia B 5 Salina C 6 Beula A 7 Apolonia F
And I would like to list all people with A's, like this:
Raisa Mellissa Emma Beula
I currently use the following formula:
Which has the output
How do I alter the formula so the following cells each show the 'next match'?