lists as parameters

  1. P

    Comparing an element of one list to the range of another list, to return the highest matching element

    Hi Everyone! What I have here are 2 input lists and a sample output list. Input List A Output Input List B aso, cro, app aso, cro, whatsapp app, data, insta whatsapp, multimedia, whatsapp app whatsapp, multimedia, peter, sam aso,cro,whatsapp insta, delta, summation app, data, insta...
  2. C

    Power Query: Search for variable within defined list

    Basically, I'm trying to validate that test answers provided are within the defined list of accepted test answer values. This problem is frustratingly simple in theory, but I'm having a difficult time figuring out a solution within Power Query (PQ). Example: I have a table of test questions and...
  3. M

    Handling Outliers

    Hey Everyone, Im still super new at this VBA stuff. But I am trying to devise a way to automatically pull data from my worksheet and exclude any outliers that is inputted by the user as "Yes" in another section of the worksheet then be able to use a basic STDEV function for the rest of the...
  4. C

    Index match with rows to find name in list

    Good day experts, I want to be able to have a team name automatically updated as I filter a database of staff. For example I have a list of staff members belonging to a team, team being an arbitrary name, such as a supervisor name. As the database grows and more teams are assembled, a whole...
  5. A

    Excel VBA HELP ! > hide & filter columns based on entries in a range on another sheet

    Hi All, I'm fairly new to coding (about 1.5 yrs basic coding) and i am stuck with this issue: I have a range "Countries" C13:C33 (in a sheet (sheet called "Selection") where a user can type a pre-determined list of countries "Austria, Spain, France etc etc. Once entered, I need the code to jump...

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