spec

  1. RobbieC

    Workbook not updating

    Hi there, I have a massive workbook which is mainly inputted via user forms. I'm running excel 2010 and everything runs fine on my computer and 3 other machines I've built with similar spec. However, I've just installed the workbook onto 2 new laptops (with same spec) and I appear to have a...
  2. M

    Conditional Formatting

    Please Help!!!:confused::rofl: I have a testdata sheet whih there is a min and max spec. i can setup the conditional formatting for less than, geater than, but here is where i am stuck.... Sometimes there is no spec but because i have a format for less/greater than it autoamatically...
  3. I

    Checking a number of measurements against constantly changing high and low tolerences.

    In my work I take around 100 different measurements. Each measurement has it's own spec for high and low tolerance. For example measurement #1 can be between 0 and 1. Measurement #4 could be between 0 and 1.5 and so on. I use conditional formatting to highlight the measurements that are...
  4. S

    returning next highest time in list

    I have a list of date and times which an item was entered into a fridge the fridge has a humidity and temperature sensor, both could indicate individually that the fridge has gone out of spec and then come back in. I have calculated a list of times the fridge is completely back in spec I now...
  5. J

    Opening a PDF using 2 comboboxes on an userform

    Greetings, I am trying put together an userform that will open a PDF file from a folder location dependent on 2 comboboxes. The first combobox gives the user a choice of 3 types, and then the second combobox will provide the user the choice of files to open. I want the user to be able to choose...
  6. L

    Insert Value into Cell Based upon Table (Multiple Criteria)

    Hello, I have a spreadsheet where I'm wanting to input the "Make", "Model", "Mast Type" and "Lift Height" and from this information, look up data in another tab and insert into my first sheet but with there being multiple criteria, I'm struggling to work it out. For example, with the "Engine...
  7. R

    Are more CPU cores better for huge Excel data sets ?

    I am building a high spec computer as below. 64GB 3200MHz DDR4 RAM 11GB GTX 1080 Ti GPU 1TB SSD PRO SM 961 M.2 Hard Drive I am in a dilemma which CPU to install My worksheets consist of up to 800,000 rows and around 75 columns, most containing formulas. size around 500-800MB. No VBA is used only...
  8. K

    VBA: Concatenate headers with data in rows below

    Hello everyone! I'm bulk converting a bunch of product content from a spreadsheet into basic HTML and I'm looking for a VBA code that lets me concatenate the product's technical specs including the header each time, but only if the cell isn't empty. The content will be displayed in lists using...

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