heavy

  1. J

    Lookup with Many Criteria

    HI I have been given a data extract, and due to the criteria I have, the formula based on all of those finally works. However, it is very heavy and slow - Calculating (4 Threads): XX% The formula is as follows...
  2. R

    vlookup with Large Sets of data

    Hello Excel Guru's, Just wanted to ask for your opinion if below formula is great for large data look ups. =IFERROR( IFERROR( IF(G2=VLOOKUP(G2,B:B,1,1), VLOOKUP(G2,B:C,2,1), VLOOKUP(G2,B:C,2,0)), VLOOKUP(G2,B:C,2,0)), "-") Thanks.
  3. J

    My micro creates generates CSV that are a way to heavy!

    I created a macro for filling out long forms and one to create a CSV file of the final form. So far so good. The problem is that the CSV files were supposed to be around 100 kb and they are 25Mb! I am almost sure that they are heavy because they are carrying the macros along wth them. How to...

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