array1

  1. J

    Array question

    I have a array with 500 records and another array with 25 numbers. These 25 numbers are between 1-500. I want too clear all the records in 500 record array which are not in the 25 records array. Array1 10, 20, 31, 32, 45, 50 Array2 20, 45 After matching the result for array1 is 0, 20, 0, 0...
    • jpen
    • Thread
    • array array1 numbers records result
    • Replies: 3
    • Forum: Excel Questions
  2. S

    Autofilter with Array as Criteria

    I am trying to autofilter a range with an array that I declared from a different range, but the autofilter will only use the last value of the array as criteria. For instance, Range("B6:B10") contains the data with which I want to filter Range("A1:A114"), but my range is only filtered by what...
  3. A

    Storing Unique Values from Advanced Filter to an Array

    Hi All, I am a VBA newbie and want to find the unique values from a column and store them to an array. I found this thread: https://www.mrexcel.com/forum/excel-questions/67144-filter-list-vba-array.html, and am trying out the post by dk with the following code: Sub CopyToRange() Dim Array1...
  4. S

    Use a defined array to derive a column/row of data to use MATCH function in INDEX function

    I have the following 2 arrays from A2:F7 (defined as Array1) and H2:M7 (defined as Array2) <tbody> Array1 Array2 6 7 8 9 10 60 70 80 90 100 1 A B C D E 10 1 2 3 4 5 2 F G H I J 20 6 7 8 9 10 3 K L M N O 30 11 12 13 14 15 4 P Q R S T 40 16 17 18 19 20 5 U V W X Y...

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