| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter?
I have 30 columns and 2000 rows, with some cells without data:
T1 T2 T3 T4 T5T30 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 T5T30 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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why won't advanced filter return filter results? | Excel Worksheet Functions | |||
| How do I use advanced filter to filter for blank cells? | Excel Discussion (Misc queries) | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
| advanced filter won't allow me to filter on bracketed text (-456.2 | Excel Discussion (Misc queries) | |||
Threaded Mode
