# Sorting Data - Multiple coluns and rows into an ordered list

1. ## Sorting Data - Multiple coluns and rows into an ordered list

I would be much obliged if someone could help me figure this out.

I have an excel sheet with 10 columns and 10 rows. Each cell contains a 6-digit number anywhere from 235764 to 387655 (invoice numbers).

Is it possible to sort the entire selection of numbers into an equal number of columns and rows but in numerical order from lowest to highest?

I want to take a sheet that looks like this:

5 4 7 3 8 9
13 2 18 1 16 6
10 11 17 12 14 15

to look like this:

1 4 7 10 13 16
2 5 8 11 14 17
3 6 9 12 15 18

Thanks!

2. Hi

Assuming your 10*10 table is in A1:J10, write in L1:

=SMALL(\$A\$1:\$J\$10,ROWS(\$L\$1:L1)+10*(COLUMNS(\$L\$1:L1)-1))
Copy down and accross

HTH
lecxe

3. Thanks! That works. You saved me lots of time.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1