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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom filtering has only two entries (and, or)? Ive got at least
TooN,
You need to use a helper column of formulas. For example, if you create a list of 'desired values' using a named range Desired The Helper formula is this, assuming your data start in row 2: =NOT(ISERROR(MATCH(D2,Desired,FALSE))) Then filter based on that column, for TRUE. HTH, Bernie MS Excel MVP "TooN" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom filtering has only two entries (and, or)? Ive got at le
Hi Bernie,
Thanks for the quick response but i dont know exactly what you mean. I tried to use the formula but i couldnt get it to work, could you explain it to me one more time? Thanks, TooN "Bernie Deitrick" wrote: TooN, You need to use a helper column of formulas. For example, if you create a list of 'desired values' using a named range Desired The Helper formula is this, assuming your data start in row 2: =NOT(ISERROR(MATCH(D2,Desired,FALSE))) Then filter based on that column, for TRUE. HTH, Bernie MS Excel MVP "TooN" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom filtering has only two entries (and, or)? Ive got at le
Select, let's say, ten blank cells. Name then Desired either using the name box or Insert names.
Then place the values that you want to show into those cells. Look at help about named ranges if you still have questions. Then use the formula that I gave you, assuming that the multiple values that you want to show are in column D, starting in row 2. Copy the formula down to match your database, and then filter on the column of formulas. If you can't get it to work, contact me privately at deitbe at consumer dot org and I will send you a working example. HTH, Bernie MS Excel MVP "TooN" wrote in message ... Hi Bernie, Thanks for the quick response but i dont know exactly what you mean. I tried to use the formula but i couldnt get it to work, could you explain it to me one more time? Thanks, TooN "Bernie Deitrick" wrote: TooN, You need to use a helper column of formulas. For example, if you create a list of 'desired values' using a named range Desired The Helper formula is this, assuming your data start in row 2: =NOT(ISERROR(MATCH(D2,Desired,FALSE))) Then filter based on that column, for TRUE. HTH, Bernie MS Excel MVP "TooN" wrote in message ... 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 |
Reply |
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) |