cleaning up

  1. E

    Cleaning formatting after last column

    Hi All, I am cleaning up an file with dispersed formatting all over the place. I know the following procedure: 1. Saving file as .xlsb file 2. Deleting formatted columns 3. Saving and closing the file When exercising step 2 I encounter a problem. My file is large and calculation power is...
  2. A

    Data selection, subtotaling, etc. Big question. Big problems. Please help!

    Hi everyone, Longtime listener first time caller. I have a couple of tasks that I am trying to complete for my boss. I am trying to rework some data and get some explanatory statistics out of it. My data set is a time series with 10 variables and about 5800 daily observations. First: I...
    • asprott
    • Thread
    • averageifs cleaning up label data points lost subtotaling
    • Replies: 3
    • Forum: Excel Questions
  3. A

    Removing Extraneous Numbers w/ Specific Format

    I have a column of names that I pass through a macro. The names get concatenated with an ID number in some cases. e.g. "Campbell" becomes "0131 Campbell" and if it passes through again it can become "4438 0131 Campbell". The number is always 4 digits and there is always a space. I was...

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