50k

  1. C

    Transform data from rows to columns

    Hi all, My raw data looks like this: The data was copied and pasted from a notepad, so each line is on a different row. <thead style="margin: 0px; padding: 0px; border: 0px; font: inherit; vertical-align: baseline;"> ====Starting details===== </thead><tbody style="margin: 0px; padding: 0px...
  2. L

    Only calculate everything under 50k

    Hi, I am using the following formula and would like to only sum everything under 50k, any help greatly appreciated Thanks =SUMPRODUCT(--('04'!$J$2:$J$100=A2),--('04'!$I$2:$I$100))
  3. G

    Error 91 in code - Object variable or with block not set

    Code below Sub AddNEW() ' ' AddNEW Macro ' Application.ScreenUpdating = False Dim LastRow As Long Dim wsData As Worksheet Dim wsMacro As Worksheet Set wsData = Workbooks("Over 50k Report.xlsm").Sheets("NEW Invoices") Set wsMacro = Workbooks("Over 50k...
  4. B

    large size spreadsheet - delete the blank stuff

    hey I'm struggling to use a spreadsheet which is 75mb so trying to cut down the amount of blank/empty rows columns on a few of the sheets there's 50k rows with data but then on about a dozen other sheets there's "only" 10k rows with data and 40k empty rows, the scroll bars are very small is...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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