lists as parameters

Hello All So im working on a data sheet for customers, and we want to replace long sample names with a key as a drop down list. So Cells A86 to A90 are the keys (A, B, C, D, E etc). and the matching / corresponding samples names are in B86 to B90 (lower level plain, upper level plain, upper...

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...

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...

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...

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...

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...