Sorting Numbers

[prthibeaux]

I have a list of 300 numbers starting in cell B:12, B:22, B:32.....all the way to B:3002. How can I sort these numbers so they all end up together at the top of the column. Thanks!

[Brian from Maui]

Originally Posted by prthibeaux

I have a list of 300 numbers starting in cell B:12, B:22, B:32.....all the way to B:3002. How can I sort these numbers so they all end up together at the top of the column. Thanks!

Highlight the whole range and Sort.

[Zack Barresse]

hiya prthibeaux (wow, thats a mouthful! you'll have to tell me how to pronounce that one!),

aside from Brian's solution (which is the best way to go), is there any data in between the cells you specified? or any other extenuating circumstances in which should be noted here for an effective solution? if not, your in good shape! just thought i'd ask.

have a great day!

[PaddyD]

or, with a formula:

******** ******************** ************************************************************************>

Microsoft Excel - Book1 ___Running: xl2000 : OS = Windows Windows 2000
File Edit View Insert Options Tools Data Window Help About
B2B3B4B5 =
	A	B	C	D
1	Num	All	*	*
2	*	1	*	*
3	*	2	*	*
4	*	3	*	*
5	*	4	*	*
6	*	*	*	*
7	*	*	*	*
8	*	*	*	*
9	*	*	*	*
10	*	*	*	*
11	*	*	*	*
12	1	*	*	*
13	*	*	*	*
14	*	*	*	*
15	*	*	*	*
16	*	*	*	*
17	*	*	*	*
18	*	*	*	*
19	*	*	*	*
20	*	*	*	*
21	*	*	*	*
22	2	*	*	*
Sheet6 *

[HtmlMaker light Ver1.10] To see the formula in the cells just click on the cells hyperlink or click the Name box
PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

formula is:

=INDEX(A:A,((ROW()-1)*10)+2)