Filter?

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
Click to expand...

Why not put a helper column;


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

and just sort
 
Back
Top