Copy & Paste in reverse order?

[Anderon]

Hi...How do I copy and paste a row of numbers to another part of the excel spreadsheet or a new one if I want, in reverse order so that the numbers at the bottom of the column to the top will now be the numbers from top to bottom in a new column or spreadsheet? Thanks in advance for the help!!

Example..

Old Column A / New Column B

1....... 10
2......... 9
3......... 8
4......... 7
5........ 6
6 ......... 5
7 ........ 4
8 ........ 3
9 ........ 2
10........ 1

 

[BigBeachBananas]

Hi...How do I copy and paste a row of numbers to another part of the excel spreadsheet or a new one if I want, in reverse order so that the numbers at the bottom of the column to the top will now be the numbers from top to bottom in a new column or spreadsheet? Thanks in advance for the help!!

Example..

Old Column A New Column B

1 10
2 9
3 8
4 7
5 6
6 5
7 4
8 3
9 2
10 1

You can simply copy and paste column A into column B => highlight column B => right-click => sort largest to smallest=> "continue with current selection"

 

[Anderon]

You can simply copy and paste column A into column B => highlight column B => right-click => sort largest to smallest=> "continue with current selection"

Ron's Roulette Tracker 10-26-21 117.xlsx
	A
2	20
3	36
4	22
5	9
6	26
7	3
8	12
9	1
10	23
11	3
12	9
13	7
14	10
15	7
16	35
17	23
18	21
19	9
20	15
21	27
22	34
23	11
4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A:A	Cell Value	>=19	text	NO
A2:A118	Expression	=FIND("|"&A2&"|","|0|")	text	NO
A2:A118	Expression	=FIND("|"&A2&"|","|1|3|5|7|9|12|14|16|18|19|21|23|25|27|30|32|34|36|")	text	NO

Hey Thanks BBB, I should of shown this analogy instead...I want to do the same here and keep the numbers in the same order so when I reverse the order from the bottom to the top they go 11 34 27 15 and so on, they stay in order. How can I do that? I don''t want to sort smallest to largest, I want to maintain the same order as the numbers are in just in reverse order. Thanks so much!!

 

[BigBeachBananas]

Ron's Roulette Tracker 10-26-21 117.xlsx
	A
2	20
3	36
4	22
5	9
6	26
7	3
8	12
9	1
10	23
11	3
12	9
13	7
14	10
15	7
16	35
17	23
18	21
19	9
20	15
21	27
22	34
23	11
4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A:A	Cell Value	>=19	text	NO
A2:A118	Expression	=FIND("|"&A2&"|","|0|")	text	NO
A2:A118	Expression	=FIND("|"&A2&"|","|1|3|5|7|9|12|14|16|18|19|21|23|25|27|30|32|34|36|")	text	NO

Hey Thanks BBB, I should of shown this analogy instead...I want to do the same here and keep the numbers in the same order so when I reverse the order from the bottom to the top they go 11 34 27 15 and so on, they stay in order. How can I do that?

In CellB2 Enter:
=OFFSET($A$23,-(ROW(A2)-1),0)
then autofill

 

[Anderon]

In CellB2 Enter:
=OFFSET($A$23,-(ROW(A2)-1),0)
then autofill

 

[Anderon]

Perfect...Thanks so much BBB, I really appreciate your help with this!!