Hi,

You can use sort. Since you don't seem to care which columns are sorted
how, you put your cursor into a single cell in column 13 and click Sort
Ascending, click a single cell in column 12 and repeat the sort. Move from
left to right doing each column once.

Alternately, choose Data, Sort and specifiy the first column as the first
sort order, and the second column as the "And then" sort order, and the 3rd
column as the 3 level sort order. Click sort. Repeat this until you have
done all 13 columns.

In 2007, you can define the sort order for all 13 columns at once and then
sort.

--
Thanks,
Shane Devenshire


"scr" wrote:

I receive a spreadsheet that has 183 rows of data and 13 columns.

I would like to sort so that they are grouped together so if anything that
matches row 1 exactly falls in line after row 1. Then the next group would
match exactly and so on.

What can I do? I tried the Exact function but couldn't get that to work but
I've never used it before. Is that something that should work in this
scenario or is there another way to do this?