Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter with Loops
Hi all,
Is there any quick ways that I can obtain all available options of eac fields? (as shown in the attachment) If not, any idea. I just came up using CountA() to get each distinc options Attachment filename: autofilter.jpg Download attachment: http://www.excelforum.com/attachment.php?postid=64478 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter with Loops
John Walkenbach shows how to get a list of unique values from a range to
populate a listbox. Maybe you could change his code: http://j-walk.com/ss/excel/tips/tip47.htm (I didn't look at the attachment.) "kaon <" wrote: Hi all, Is there any quick ways that I can obtain all available options of each fields? (as shown in the attachment) If not, any idea. I just came up using CountA() to get each distinct options. Attachment filename: autofilter.jpg Download attachment: http://www.excelforum.com/attachment.php?postid=644783 --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Autofilter with Loops
Ouch~ Tough that's not what I want excatly, but it still works!
Thanks, guy! --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel 2007 autofilter change to 2003 autofilter functionality? | Excel Discussion (Misc queries) | |||
2007 excel autofilter change back to 2003 autofilter? | Excel Discussion (Misc queries) | |||
Loops | Excel Discussion (Misc queries) | |||
Do Loops | Excel Programming | |||
Loops | Excel Programming |