re-order

  1. Dr. Demento

    Sheet codename order in VBE

    I have a large number of worksheets (>200) and because Excel places the sheets in order of codename and because the codenames are alphanumeric, I wind up with an order like Sheet1, Sheet100, Sheet101, etc. Is there a way re-order the sheets so they are in either the same order as the tabs or at...
  2. P

    re-order a list based on different citeria

    A little while ago i was give this formula to help me re-order a list based on the fact that it is mixed letters & numbers. IE if a letter "R" is in the list then it becomes 1, if in the same list a 1 appears this becomes a 2 & so on =IF(A1="R",1,IF(A1=0,MAX(A$1:A$11)+COUNTIF(A$1:A1,0)+1,A1+1))...
  3. P

    re order columns on value

    45 58 02 30 56 in Columns A1 to E1. How can I re-order low to high please?

This Week's Hot Topics

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
Top