matching arrays

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

    Returning values if cells in array contain specific text

    G'Day everyone, I hope I can explain this one well enough because I haven't found any helpful hints/clues as yet. I have a training spreadsheet with two worksheets. One sheet is a matrix (Matrix worksheet.png) of courses/course descriptions and employed positions. There's an area on that sheet...
  3. M

    Indexing & Double Matching Formula?

    <tbody> Center Jan 2017 Feb 2017 March 2017 April 2017 363 263 532 209 120 5032 120 111 123 678 </tbody> <tbody> Center Date Packages 363 Jan 2017 263 363 Feb 2017 532 363 March 2017 209 363 April 2017 120 5032 Jan 2017 120 </tbody> The top table is how I currently have my...
  4. M

    Matching arrays

    I am creating a new timetable in a school and have the following problem. The students have opted for different subjects and I have create the below: Id Sex Surname Called Name Form Returning Key Biology Business Std Chemistry Spanish (x2) PE Classicsal Civ German History Maths Physics...

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