Filter?

G

Guest

I have 30 columns and 2000 rows, with some cells without data:
T1 T2 T3 T4 T5â€¦â€¦â€¦T30
Case1 x x x x x
Case2 x x x x x
Case3 x x x
Case4 x x
Case5 x x x x x
Case6 x x x x
Case2000 x x x x x x

and I need a selection like this :
T1 T2 T3 T4 T5â€¦â€¦â€¦T30
Case2 x x x x x
Case3 x x x
Case5 x x x x x
Case2000 x x x x x x

Where cases 2, 3, 5 and 2000 are selected, because they share at least T1,
T3 and T30 with data in its cells. This is the â€œmaximum number of cases
sharing the maximum number of columns having informationâ€. How can I perform
this kind of selection? Any suggestion would be very appreciated, Thanks.

M

Matthew

I have 30 columns and 2000 rows, with some cells without data:
T1 T2 T3 T4 T5.........T30
Case1 x x x x x
Case2 x x x x x
Case3 x x x
Case4 x x
Case5 x x x x x
Case6 x x x x
Case2000 x x x x x x

and I need a selection like this :
T1 T2 T3 T4 T5.........T30
Case2 x x x x x
Case3 x x x
Case5 x x x x x
Case2000 x x x x x x

Where cases 2, 3, 5 and 2000 are selected, because they share at least T1,
T3 and T30 with data in its cells. This is the "maximum number of cases
sharing the maximum number of columns having information". How can I perform
this kind of selection? Any suggestion would be very appreciated, Thanks.

Why not put a helper column;

=if(and(t1="x",t3="x",t30="x"),"Ok","")

and just sort