500k

  1. J

    Using Top Values to export a range of records

    I have a very large table of 3 million records that I need to export out of ACCDB in chunks of 500k records at a time. They are sorted in a particular order so their Primary IDs are not sequential. I can easily export out the first 500k by setting the Top Values property to 500,000. Is there...
  2. L

    if statement

    Hi, Im using excel 2016, im trying to add i believe an if statement? into a cell but i dont know how to or if its the right statement to add Col BP2:BP20446 contains revenue amounts (different amounts per row) i want column DS to have the result. so if BP2:BP20446 is <100K or between 100K &...

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