Skip "False" in IF and continue numbering in cell until True match, then move down cell

I'm not sure if this is achievable, but hopefully so.

I'm using two IF's in one formula (lets say in A1) that is searching through a range of data on another worksheet. If both conditions are met, it returns an email address, and FALSE if False.

Basically, I'd like the formula to skip the false and only fill trues, meaning that when I auto filled from A1 I would have a nice column full of email addresses.

At the minute it just looks like a column full of Falses mixed with the odd email addresses.

I know I can filter out the falses, but I would like to make a macro on this one.

Any help (or indication that it can't be done) would be grand!

Thanks all,

Si

Excel test - remove rows not in use (appear as false).xlsxExcel test - remove rows not in use (appear as false).xlsx

Okay, I think this is attached. I've changed the data, but the principle is still the same.

I've heard indexing would work for this, but I don't properly understand how to use it.

NOTE: you can see in column A that I've used a concatenate formula. This is because I want to contact all people who have listed an interest in (let's say... 4) as either an "Interest 1" or "Interest 2"


Also, you can see I've added a sort of search box in column B2. I'm using this as a reference as I think i'd like to macro this for other people to use, eventually.

Happy to hear suggestions on better ways to do this if you come across one

Thanks guys!