Thread: Filter?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Maximus Maximus is offline
external usenet poster
 
Posts: 5
Default Filter?

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.