Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom filtering has only two entries (and, or)? Ive got at least
Hello,
Ive got a problem with filtering. Ive got a sheet with at least 20 columns and about 1000 rows. In column D there are all different activitys. I shall give you an example what column D looks like: 0005 0005 0006 0006 0007 0007 0008 0008 0008 0008 0009 0009 0011 0011 0012 0012 0020 002B 002B 002B 002B 0030 003C 003C 0040 0050 005A 005A 0025 004C 004C etc. etc. When i want one or two activities its not a problem, i can use the filter option and than go to custom. The problem is that i always need more than 2 activities. Is it possible to create a macro that allows me to enter as much activities as i want. After entering these activities (maybe in a popup??) Column D shows these activities and ofcourse the whole line... Please help me with this, its killing me!!!! Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula - count NÂș of entries but with other filtering criteria | New Users to Excel | |||
filtering for repetitive entries | Excel Discussion (Misc queries) | |||
filtering entries in an excel costs schedule? | Excel Worksheet Functions | |||
advanced filtering based on entries ABOVE those I wish to keep | Excel Discussion (Misc queries) | |||
count the number of cell entries after filtering | Excel Discussion (Misc queries) |