I really would like to do this using a formula or code instead of filter or pivot. Let me just explain again and you will understand formula makes much better sense. Basically, what I really want to do is have a drop down listing of all 50 states where the user will pick a state and than you will see the listings of all unique county pop us in the following manner.
State: NY (drop down option) County: Kings Queens Bronx State: NJ County: Essex Bergen thanks! On Aug 11, 1:53 am, who <dlanm...@att.net> wrote: > I guess these are in ColA and ColB. In ColC =CONCATENATE(A1,B1), then > sort, then filter unique values. > > Or the counties are all different? If so sort the counties only, > combined and find unique values. > > If the above not work, then code. let me know. > David > > On Aug 9, 1:06 pm, daruM <paradiselong...@gmail.com> wrote: > > > > > Hello, I have the following data in sheet1. > > State County > > NY Kings > > NY Kings > > NY Queens > > NY Kings > > NY Bronx > > NJ Essex > > NJ Bergen > > NJ Essex > > > In sheet 2, I need to bring in all unique county for the state. So > > for NY, I need to bring in Kings, Queens, and Bronx. For NJ, I will > > need to bring in Essex and Bergen. > > NY Kings > > Queens > > Bronx > > > Is this possible to do especially bringing in only the unique county > > not just matched county? > > > thanks!- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
