Transpose in Excel 2010

Hi all,

Goal: To trim an array down to include onlt specific rows that match a certain criteria.

[U]Attempts and workings:[/U]I have a range of data assigned to a variable that creates an Array. Works Great.

My array consists of approximately 700 rows and 100 coulmns Arr(700,100).

I need to extract only the rows whose ID (2nd coulmn) matches a prepared list of numerical values which would potentially leave me with an array of minimum Arr(1,100).

I found I couldn't reassign the array x values then shorten the array using redim preserve because that only allows the alter of the y value in an Arr(x, y).

I was then forced to transpose the array first so that I could then reduce the y value as rows (now columns) were eliminated.

Problem is I get Error 13 (Type Mismatch) on the transpose.

I realize there is a limitation on the number of values for the original x value but 700 original rows is well within the limits of the transposed y value in Excel 2010.

My Ask: I need help on trimming a 2D Variable Array that is 700 rows by 100 columns to only those rows whose 2nd column matches a value or is contained in a list of values? Min new Array size would be 1, 100

Please Login or Register  to view this content.

Table 1 is 700 rows x 100 columns

Error occurs on Transpose line. Please help.