ISNA Match Formula - how to remove the "nul" cells

[Reeves77]

Hi All,

Looking for help to formula that I have in place:

Attached xls sheet

Col A Col B Col C
Full Report Extract Data from A missing in B

Current formula

Please Login or Register  to view this content.

Gives correct results but can I get the result without the null cells (like if I was to do a simple Index/match formula)


Thanks in advance for any assistance
Peter

[kersplash]

Do you mean you want the first visible result in C1 and so on skipping the blank results and only showing the visible ones?

[Reeves77]

Yep, that is correct thanks Kersplash

[Bo_Ry]

Please try at D1 and copy down

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$1:$A$99)/ISNA(MATCH(A$1:A$99&"*",B:B,0)),ROWS(D$1:D1))),"")

[Reeves77]

Awesome - thanks Bo,

Seems to work as I want it to - a great help