Shortest column in array?

[StrawS]

I have an array with two dimensions: a(1 to 8, 0 to 15).

When represented as a table, the first dimension would be columns and the second rows (ie: 8 columns, 15 rows).

Each column has a different number of rows used, ie:
column 1 has data in row 1 through 5,
column 2 has data in rows 1 through 10,
column 3 has data in rows 1 through 15,
column 4 doesn't have data in any row, etc

row 0 is always blank.

how can i find which column is shortest (not including blank columns)?

 

[jindon]

I have an array with two dimensions: a(1 to 8, 0 to 15).

When represented as a table, the first dimension would be columns and the second rows (ie: 8 columns, 15 rows).

Wrong.

1st dim is Row and 2nd is Column

Each column has a different number of rows used, ie:
column 1 has data in row 1 through 5,
column 2 has data in rows 1 through 10,
column 3 has data in rows 1 through 15,
column 4 doesn't have data in any row, etc

row 0 is always blank.

how can i find which column is shortest (not including blank columns)?

You don't seem to understand what I meant...
Should be a(1 To 8, 1 To 15)

Why do you want to find the blanks in the array?

P.S
If you use array, learn the nature and basics of array first.

 

[StrawS]

Wrong.

1st dim is Row and 2nd is Column

ok, I want to find the longest row.

You don't seem to understand what I meant...
Should be a(1 To 8, 1 To 15)

ok...

• Each row has a different number of columns used, ie:
  row 1 has data in columns 1 through 5,
  row 2 has data in columns 1 through 10,
  row 3 has data in columns 1 through 15,
  row 4 doesn't have data in any column, etc

Why do you want to find the blanks in the array?

You don't seem to understand what I meant...
I don't want to "find the blanks in the array"
I want to find the "shortest column in the array" (as per the thread subject)
... or as you have changed it - the shortest row in the array

 

[jindon]

You don't seem to understand what I meant...
Should be a(1 To 8, 1 To 15)

ok...

• Each row has a different number of columns used, ie:
  row 1 has data in columns 1 through 5,
  row 2 has data in columns 1 through 10,
  row 3 has data in columns 1 through 15,
  row 4 doesn't have data in any column, etc

You don't seem to understand what I meant...
I don't want to "find the blanks in the array"
I want to find the "shortest column in the array" (as per the thread subject)
... or as you have changed it - the shortest row in the array

Each row/column in the array should have same size....
You really need to learn the basics of the array

 

[StrawS]

yes, I understand that each row of the array is essentially the same length. I am referring to the data contained in each row:

when I said

Each row has a different number of columns used

i meant that they all have the same number of columns, but each row has a different number of columns *used*.

I even gave an example to illustrate the point.
maybe I need to elaborate so it's easier to understand...

• row 1 has 15 columns but has data in columns 1 through 5,
  row 2 has 15 columns but has data in columns 1 through 10,
  row 3 has 15 columns and has data in columns 1 through 15,
  row 4 has 15 columns but doesn't have data in any column
  etc

 

[jindon]

then you need to loop through the array to check how many non-empty elements are there in each row.

 

[StrawS]

that sounds like a tedious method, is there no command to use that will return the last column with data in a particular row of an array?
or the first blank column in a particular row?

 

[jindon]

NO

 

[StrawS]

right. That's what I needed to know.
Thank you