swaping

  1. S

    VBA to swap values

    Hi, I have a large dataset, about 4000 rows, which I need to correct some values in case of a criteria. Below is the example of my data: <tbody> Order ID Product Type Dollar Amount 11 Low grade 20 11 Premium 35 11 Low grade 10 12 Premium 50 12 Premium 20 12 Low grade 10 12 Low...
  2. B

    swaping values by using cell Reference

    I have a data in A3 TO D10 A3=List B3=Register No C3=Class No D3=Amount i usually get the data daily,i am keep swaping values if the amount is high it should come in 1st place..is it possible if i give data in A11:D11 can i swap to 3rd Place? based on amount ex:100000 in D4 9000 in d5..etc it...

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