Refiining data in excel
Hi Rob,
Another one along the same lines.
In your helper column put 1 in the first cell, grab the fill handle
and drag it down 10 rows hold down ctrl then release the left
mouse button then release the ctrl button. You've now got
1 to 10 in the first 10 cells, while they are still highlighted
grab the fill handle again and drag down to the end of your
data then repeat the ctrl button bit and you will have a repeating
series of 1 to 10 running down your column.
Then use autofilter to sort your info and copy and paste to
a new sheet.
HTH
Martin
|