Thread: Read in Array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
leigh leigh is offline
external usenet poster
 
Posts: 2
Default Read in Array

I know this should be simple, but I want to read in an array (2 rows, about 10 columns). The 1st row is G1: K1 and the second is G90:K90. I want to sort by row 2 and output the top 5 values in a column (so, transposed). I've got the sort down, but I'm unsure of how to read in the two rows.