reverse order

  1. S

    Reverse sort within cell option for this VBA code

    Hello! I'm new to VBA and first would like to thank everyone posting codes that anyone can use!! I've found this very useful code to alphabetically sort words within cell separated by a comma. I'm wondering if i can tweak this to reverse sort? (Z-A instead of A-Z) Function StrSort(ByVal sInp...
  2. E

    Reversing the order of an array within SUMPRODUCT

    Okay, the good news is what I've done works perfectly. The bad news is I don't know what I've done or, more specifically, I can't explain it to a third party. A brief description: Row 2 contains the months from inception. Row 3 shows the recovery vector for any cycle of new defaulting assets...
  3. M

    Reverse order

    Hey looking to see if there is a way to calculate a reverse order, I have to reverse 3k cells and want to know if there is just a way I can start with the top cell to be D1-->[=C3000] then D2-->[=C2999] then D3-->[=C2998]...and so on. I was thinking some type of offset function but cant seem to...
  4. V

    Reversing Order of Values in Range Variable

    I have a function that receives values from a worksheet as a Range variable: Public Function Interpolate(x As Double, Xi As Range, Yi As Range) Lets say that Xi has two values, which I can access like: x1 = Xi(1) x2 = Xi(2) I want to reverse the two values, and I don't seem to be able to...
  5. A

    VLOOKUP - Negative / Reverse Column Reference - Search "B" and return data from "A"

    I program radios... some take only 8 characters, some 12, others 14, and some 20. To keep things simple we decided to only allow two options... 12 Characters and 8 Characters. So if the radio has 11 characters allowed... use the 8 character name. We set up a (huge) spreadsheet with all the...

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