Userform Combobox, only include rows where column x = value

[Kyletok]

I have a combobox list that I populate with

Private Sub UserForm_Initialize()
Me.ComboBox1.List = [Accounts].Columns("A:B").Value
End Sub

the combobox has 2 columns, with the first one being bound:
which works wonders as It shows me the account number and the vendor it belongs to.

some account numbers can exist more than once as long as they belong to different vendors. The vendors repeat many times as accounts and vendors have a one to many relationship.

So it's important to point out that I am not looking to find unique values in either column, as I need the duplicates to remain just like when you would filter through a table filter.

so here's what I am trying to achieve:
I want to filter through the rows that are included in the combobox, depending on the value on column D (or 4)

Column D is the assigned analyst to the account - I want analysts to only have the accounts that belong to them populate to the combobox.

is there a way to filter [Accounts].Columns("A:B").Value, to only include rows where Column 4 = "Ariel" (for example).

thanks in advance for any input

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...ombobox-userform-post5218509.html#post5218509

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).