Need to either sort by row 2 skip 1, row 4 skip 3. and so on. Or delete or cut even number row befor sorting.

speedracer7278

New Member
Joined
Aug 24, 2007
Messages
11
Office Version
  1. 365
Platform
  1. Windows
Would like to know how to sort only by the even rows. Also how to cut all even row and paste to another sheet. Working with over 350 rows at a time.

Resspectfully
Rake.
 
you can sort on the even rows by using a "helper" column which takes a value from the column you want to sort on directly if the row number is even and from the value in the row above in the helper column if the row number is odd, and then sort on this column . I assumed the column you want to sort on is in Column B and I put my "helper " column in column C
Copy down to the bottom of the column C and then sort on the helper column
Excel Formula:
=IF(MOD(ROW()-1,2)=1,B2,C1)
 
Upvote 0
Thanks but I need the odd numbered row not to be involved in sorting: And move or delete odd number row from selected cells.

677 678
678 680
679 682
680 684
681 686
682 688
683
684
685
686

Respectfully Speed.
 
Upvote 0
Is this how you want?

Excel Formula:
=LET(x,A1:A1000,SORT(FILTER(x,(x<>"")*(MOD(ROW(x),2)=0))))
 
Upvote 0

Forum statistics

Threads
1,226,831
Messages
6,193,206
Members
453,779
Latest member
C_Rules

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top