title: Check if combination of values matches values in a range
body: <p>I'm quite new to VBA and struggle with to following: I have a sheet of about 1000 rows, each row represents a client record. The first column is the clients id number, next 10 columns are the meds the client uses. I want to find which clients use a certain combination of meds. So, I have a form to select the meds, let's say combobox1 gives me Med1, combobox2 gives Med2 and so on until a combination of 5 meds. I know how to find how many clients use 1 selected med, but I have no clue how to find a combination. So, I want to find howmany clients uses the combo of med1 + med2 +...+ med5.
  Can anyone help me with this? Thank you so much in advance!</p>