Hi,
I have a Table 1 containing three columns, where each row contains a combination of entries across the three columns. Some rows have three entries, while others have only two, one or also zero entries.
I need a formula in Table 2 that removes rows which are contained within other rows in the table, meaning that blank cells function as some kind of "wildcard".
E.g. in the following four rows, only the fourth row would be kept since this row contains row one, two and three:
14384954 14384954 14384960 14384954 14384960 14381225 14384954 14384960 14381225
While in the following example, both rows two, three and four would be kept and row one would be removed:
14384954 14384954 14384960 14384954 14384973 14384954 14381225
If this formula could be a dynamic array formula which spills the results across three columns in Table 2, that would be nice.
Also, if this formula would be able to sort the results in Table 2 by column E, then column F and then column G in ascending order, but pushing blanks to the bottom - as can be seen in Table 3 - that would be very good. A formula to achieve both Table 2 and Table 3 in one go would be perfect.
I have attached a an example workbook containing the relevant setup.
Best regards,
Marbleking
Bookmarks