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