I will be reading a CSV file with 15 columns and x (normally about 500) rows. It will be hard to tell visually whether I am getting the results I expect, so I wanted to come here first. The entire array will be DIMed starting from 1,1 rather than 0,0.
I have to sort first on column 3, then sort on column 12, and finally sort on column 2. I do not want any columns re-arranged. The data in column 5 will stay in column 5, but the entire row would move up or down in the array as the columns require.
How should I set up these ARRAY SORTs to be sure I get the intended result?
I have to sort first on column 3, then sort on column 12, and finally sort on column 2. I do not want any columns re-arranged. The data in column 5 will stay in column 5, but the entire row would move up or down in the array as the columns require.
How should I set up these ARRAY SORTs to be sure I get the intended result?
Comment