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.
 
Ad

Advertisements

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top