Ranking columns of data in a series of matrices

G

Graham Whitehead

Hi, i am trying to write something which will scan through a number of
worksheets which contain matrices. So I am storing the values of each matrix
in an array. I now need to find a way to rank the values in each column
relative to that column of data. My question really is, is there a way to
specify that particular column as a range and then rank the values by
referencing a value in the array against the defined range? So for example
the first value in the first column - array(0,0) against a range defined as
rngColumn1, then array(1,0) against the same range...and so on.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Arrays and scattered cell values or another way? 16
Search an array of sheets for an array of numbers & return count of numbers 11
Loop is slow trying array code 17
Setting column width in a table with a macro is not working 0
Six columns randon no.'s no dupes 6
Convert list to UPPER, lower & Proper cases. 21
Assign Ranges On Different Worksheets. 5
The Road- Matching data within a range of values 1

Top