Please help! I have a block of numerical data and I want excel to organize this from smallest number to largest and keep it in the table format. This is not a list, it's a block of numbers. I want them in order. I can't figure out how to sort it. Please help!
An old query, never answered, I have the same problem, I have a block of numbers, 11 columns wide by 22 rows, no headers, just a big bock of numbers not yet in numerical order. There must be a way to sort this out into the correct order, I can do one column at a time, one row at a time but not the whole block.
Just in case I have left you high and dry, a way of creating the sequence 'k' is first to define a dummy array reference in the top left hand corner of the sheet. You are not interested in its content but it will allow you to use row and column numbers to generate the sequence 'k'. In name manager, add a new Name 'dummy' and let it refer to