have nbrs in column b 1 - 10 repeated many times over
Would like to sort repeaded 1 - 10 / 1 - 10 This would create groups
from 1 - 10
can this be done in excel ?
Any Help greatly appreciated.
Thank You

in Column C put in this formula in the first row

=countif($B$1:B1,B1)

then drag fill down the column.

Now sort the data on This column first, then column B as the second key.



--
Regards,
Tom Ogilvy


"Curt" wrote in message
...
have nbrs in column b 1 - 10 repeated many times over
Would like to sort repeaded 1 - 10 / 1 - 10 This would create groups
from 1 - 10
can this be done in excel ?
Any Help greatly appreciated.
Thank You

maybe i didn't follow still get all1s together 2s together not a 1 2 3 4 5
repeat sort
not to good at this
Thanks


"Tom Ogilvy" wrote:

in Column C put in this formula in the first row

=countif($B$1:B1,B1)

then drag fill down the column.

Now sort the data on This column first, then column B as the second key.



--
Regards,
Tom Ogilvy


"Curt" wrote in message
...
have nbrs in column b 1 - 10 repeated many times over
Would like to sort repeaded 1 - 10 / 1 - 10 This would create groups
from 1 - 10
can this be done in excel ?
Any Help greatly appreciated.
Thank You