Creating List of Unique Values From Filtered Database

A

Ark68

Well-known Member
Joined
Mar 23, 2004
Messages
4,564
Office Version
  1. 365
  2. 2016
Platform
  1. Windows
Consider my database.


Excel 2003
ABCDE
1
2Type2ActivityOrganizationLeagueCalibre
3DIA3-PitchWCDSBSt. Davids BoysSCH
4DIA3-PitchRegion of WaterlooHealthy LifestylesREC
5DIA3-PitchWCDSBSt. Davids GirlsSCH
6FLDSoccer (Atom)WMSAAtomHL
7FLDSoccer (Atom)Misc.AtomREC
8FLDSoccer (Atom)KW SoccerAtomREC
9FLDSoccer (Atom)Grand River SoccerAtomREC
10DIABaseballWMBABantamHL
11DIABaseballWMBABantamREP
12DIABaseballMisc.BantamREC
13DIABaseballWMBAMidgetHL
14DIABaseballWMBAMidgetREP
15DIABaseballMisc.MidgetREC
16DIABaseballWMBAT-Ball (Minor)HL
17DIABaseballWMBAT-Ball (Major)HL
18DIABaseballMisc.T-BallREC
19DIABaseballWMBAPeeweeHL
20DIABaseballWMBAPeeweeREP
21DIABaseballMisc.PeeweeREC
22DIABaseballMisc.RecreationalREC
23DIABaseballWLU (Intramural)MLSBREC
24DIABaseballKW Rec BaseballRecreationalREC
25DIABaseballWMBARookieballHL
26DIABaseballWMBARookieballREP
27DIABaseballMisc.RookieballREC
28DIABaseballWMBATykeHL
29DIABaseballWMBATykeREP
30DIABaseballMisc.TykeREC
31CRTBeach VolleyballCARLCoedREC
32CRTBeach VolleyballMisc.CoedREC
33FLDCricketKaituer CricketCricketREP
34FLDCricketWaterloo-Sunrise CricketCricketREP
35FLDCricketAR CricketCricketREP
36DIAFastballKWMBFABantamREP
37DIAFastballKWMBFABantamHL
38DIAFastballMisc.BantamREC
39DIAFastballKWMBFAMiteREP
40DIAFastballKWMBFAMiteHL
41DIAFastballMisc.MiteREC
42DIAFastballKWMBFANoviceREP
43DIAFastballKWMBFANoviceHL
44DIAFastballMisc.NoviceREC
45DIAFastballKWMBFASquirtREP
46DIAFastballKWMBFASquirtHL
47DIAFastballMisc.SquirtREC
48DIAFastballMisc.MensREC
49FLDField HockeyWRDSBSchoolSCH
50FLDField HockeyWCDSBSchoolSCH
51FLDField HockeyMisc.SchoolREC
52FLDFootballTCMTFYouthREP
53FLDFootballWRDSBSchoolSCH
54FLDFootballWCDSBSchoolSCH
55FLDFootballMisc.AdultREC
56FLDFootballWLU (Varsity)AdultSCH
57FLDLacrosse (Men's)WLU (Varsity)MensSCH
58FLDLacrosse (Men's)Misc.MensSCH
59FLDLacrosse (Men's)KWMLAMensREP
60FLDRugbyWRDSBSchoolSCH
61FLDRugbyWCDSBSchoolSCH
62FLDRugbyMisc.AdultREC
63DIASlo-Pitch (Co-Ed)CARLCoedREC
64DIASlo-Pitch (Co-Ed)Misc.CoedREC
65DIASlo-Pitch (Co-Ed)Waterloo Rec Coed Slo-Pitch (Pacey)CoedREC
66DIASlo-Pitch (Co-Ed)Waterloo Chippers Slo-PitchMensREC
67DIASlo-Pitch (Co-Ed)All In The Family Slo-PitchMensREC
68DIASlo-Pitch (Co-Ed)Wloo Mens Slo-Pitch (Ali)MensREC
69DIASlo-Pitch (Men's)CARLMensREC
70DIASlo-Pitch (Men's)Misc.MensREC
71DIASlo-Pitch (Men's)WRDSBMensSCH
72DIASlo-Pitch (Women's)WRDSBWomensSCH
73DIASlo-Pitch (Women's)Misc.WomensREC
74DIASoftballWMGSABantamHL
75DIASoftballWMGSABantamREP
76DIASoftballMisc.BantamREC
77DIASoftballWMGSAMidgetHL
78DIASoftballWMGSAMidgetREP
79DIASoftballMisc.MidgetREC
80DIASoftballWMGSAMini-MiteHL
81DIASoftballWMGSAMini-MiteREP
82DIASoftballMisc.Mini-MiteREC
83DIASoftballWMGSAMiteHL
84DIASoftballWMGSAMiteREP
85DIASoftballMisc.MiteREC
86DIASoftballWMGSANoviceHL
87DIASoftballWMGSANoviceREP
88DIASoftballMisc.NoviceREC
89DIASoftballWMGSASquirtHL
90DIASoftballWMGSASquirtREP
91DIASoftballMisc.SquirtREC
92DIASoftballWMGSAT-BallHL
93DIASoftballWMGSAT-BallREP
94DIASoftballMisc.T-BallREC
95DIASoftballWLU (Varsity)WomensSCH
96DIASoftballMisc.WomensREC
97FLDSoccer (Squirt)WMSSquirtHL
98FLDSoccer (Squirt)Misc.SquirtREC
99FLDSoccer (Squirt)Royal City SoccerSquirtSCH
100FLDSoccer (Standard)WMSWMS - U11 B/GHL
Reference_Grp
br />

I would like to apply a filter to column A based on user selection, either DIA, FLD, or CRT.
This will result in onlt the DIA records exposed.


Excel 2003
ABCDE
2Type2ActivityOrganizationLeagueCalibre
3DIA3-PitchWCDSBSt. Davids BoysSCH
4DIA3-PitchRegion of WaterlooHealthy LifestylesREC
5DIA3-PitchWCDSBSt. Davids GirlsSCH
10DIABaseballWMBABantamHL
11DIABaseballWMBABantamREP
12DIABaseballMisc.BantamREC
13DIABaseballWMBAMidgetHL
14DIABaseballWMBAMidgetREP
15DIABaseballMisc.MidgetREC
16DIABaseballWMBAT-Ball (Minor)HL
17DIABaseballWMBAT-Ball (Major)HL
18DIABaseballMisc.T-BallREC
19DIABaseballWMBAPeeweeHL
20DIABaseballWMBAPeeweeREP
21DIABaseballMisc.PeeweeREC
22DIABaseballMisc.RecreationalREC
23DIABaseballWLU (Intramural)MLSBREC
24DIABaseballKW Rec BaseballRecreationalREC
25DIABaseballWMBARookieballHL
26DIABaseballWMBARookieballREP
27DIABaseballMisc.RookieballREC
28DIABaseballWMBATykeHL
29DIABaseballWMBATykeREP
30DIABaseballMisc.TykeREC
36DIAFastballKWMBFABantamREP
37DIAFastballKWMBFABantamHL
38DIAFastballMisc.BantamREC
39DIAFastballKWMBFAMiteREP
40DIAFastballKWMBFAMiteHL
41DIAFastballMisc.MiteREC
42DIAFastballKWMBFANoviceREP
43DIAFastballKWMBFANoviceHL
44DIAFastballMisc.NoviceREC
45DIAFastballKWMBFASquirtREP
46DIAFastballKWMBFASquirtHL
47DIAFastballMisc.SquirtREC
48DIAFastballMisc.MensREC
63DIASlo-Pitch (Co-Ed)CARLCoedREC
64DIASlo-Pitch (Co-Ed)Misc.CoedREC
65DIASlo-Pitch (Co-Ed)Waterloo Rec Coed Slo-Pitch (Pacey)CoedREC
66DIASlo-Pitch (Co-Ed)Waterloo Chippers Slo-PitchMensREC
67DIASlo-Pitch (Co-Ed)All In The Family Slo-PitchMensREC
68DIASlo-Pitch (Co-Ed)Wloo Mens Slo-Pitch (Ali)MensREC
69DIASlo-Pitch (Men's)CARLMensREC
70DIASlo-Pitch (Men's)Misc.MensREC
71DIASlo-Pitch (Men's)WRDSBMensSCH
72DIASlo-Pitch (Women's)WRDSBWomensSCH
73DIASlo-Pitch (Women's)Misc.WomensREC
74DIASoftballWMGSABantamHL
75DIASoftballWMGSABantamREP
76DIASoftballMisc.BantamREC
77DIASoftballWMGSAMidgetHL
78DIASoftballWMGSAMidgetREP
79DIASoftballMisc.MidgetREC
80DIASoftballWMGSAMini-MiteHL
81DIASoftballWMGSAMini-MiteREP
82DIASoftballMisc.Mini-MiteREC
83DIASoftballWMGSAMiteHL
84DIASoftballWMGSAMiteREP
85DIASoftballMisc.MiteREC
86DIASoftballWMGSANoviceHL
87DIASoftballWMGSANoviceREP
88DIASoftballMisc.NoviceREC
89DIASoftballWMGSASquirtHL
90DIASoftballWMGSASquirtREP
91DIASoftballMisc.SquirtREC
92DIASoftballWMGSAT-BallHL
93DIASoftballWMGSAT-BallREP
94DIASoftballMisc.T-BallREC
95DIASoftballWLU (Varsity)WomensSCH
96DIASoftballMisc.WomensREC
138DIA3-PitchMisc.CoedREC
139DIAFastballJr. Hallman TwinsMensPRO
140DIAFastballKWMBFAMidgetREP
141DIAFastballKWMBFAMidgetHL
142DIAFastballMisc.MidgetREC
143DIAFastballKWMBFAPeeweeREP
144DIAFastballKWMBFAPeeweeHL
145DIAFastballMisc.PeeweeREC
Reference_Grp


What I would like to do, is create a list of unique values in column B based on the filtered data. This list will be used in a userform combobox for the user to select from.

Then, using a similar method, this selected value will be then chosen to filter column B. Based on the resulting filtered database, similar code will be used to isolate the unique values in column C, for yet again another combobox.

These pocedures are basically a form of validation, allowing users to only select available selections for relevant choices.

Is this logic appropriate? How would I go about doing this? I am a novice coder, and would welcome any support to accomplish this feat.

Jenn
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.
You must log in or register to reply here.

Forum statistics

Threads
1,214,985
Messages
6,122,605
Members
449,089
Latest member
Motoracer88

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top